New SQL Express install - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

New SQL Express install

Author

Topic

ggaudreau
Starting Member

2 Posts

Posted - 2008-04-21 : 14:03:57

Hi all,

I am trying to setup a small database on an XP system. Installed SQL Express, installed Management studio Express - no errors

I create a user called Joe using SQL server authentication
I create a database and make Joe the owner

I then try to connect to the database using the Joe account and get an error saying that

Cannot connect to JOE-PC\SQLEXPRESS

Additional Information:
Login failed for user joe. The user is not associated with a trusted SQL Server Connection

I then try to do a reverse telnet on 1433 and get an error so I am guessing that there is no listener on that Port.

I remember seeing something needing starting when running express?

What am I not seeing?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-21 : 22:38:18

Did you enable mixed authentication on the server? Double check server properties -> security in ssmse.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources