SQL Server 2005 Express - Remote Connections don't work 1

[BennySHS]

Hi there,

I'm a newbie with the Mssql-Server, and short time after installation I encounter the first problems I can't solve by myself :[

I try to connect (locally) to my server with the 'SQL Server authentication' method, but always get the error 18452:

'The user is not associated with a trusted sql connection'

I googled a lot, found some tutorials and microsoft guides.

I activated TCP/IP in the 'SQL Server Configuration Manager', created an account under the 'microsoft sql server management studio express', restartet the server, restartet whole machine...I don't get it work, I always get the 18452-Error .

Is there something I've missed ?
Thx for your help,
greets ben

 

[gmmastros]

You need to modify the authentication mode to mixed.

1. Open the Sql Server Management Studio
2. Right click on the server
3. Click Properties
4. Click Security (on the left side of the window).
5. Make sure the 'Server Authentication' is set to 'SQL Server and Windows Authentication mode'


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

Also, in the 'Server Properties' window, click connections, and make sure 'Allow remote connections to this server' is enabled.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[BennySHS]

Hi gmmastros,

thx for your answer.

I'm working with SQL Server 2005 Express, could you explain how to do it there ?

Thx in advance,
greets,
ben

 

[gmmastros]

It should be the same regardless of express vs. professional, etc...

SQL Server Express 2005 ships with the Management studio. The step I gave were for the management studio. You may also want to check to see if there is a firewall turned on. Also, please note that the connection string you use for SQL 2005 is different than the connection string you use for sql2000. Go to

http://www.connectionstrings.com

for more details on connection strings.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom