Can not open User Default Database Login failed

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

General SQL Server Forums

New to SQL Server Programming

Can not open User Default Database Login failed

Author

Topic

pvenkatesh2k4
Starting Member

6 Posts

Posted - 2008-06-13 : 01:32:04

hi to all,
I am new to Sqlserver. in my machine i installed sqlserver2000.i created/registered a new server with sql authentication. but when i connecting it shows the login failed and i am unable to connect my database.after that i edited the server registration information as windows authentication. now it works well. what to do? how to tactic this problem? thanks in advance..

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 01:40:17

Using your windows account, modify the sql account's default database to one that it has access to. You can do this in Enterprise Manager, under Logins, double click the userid.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-13 : 01:40:34

Do you have a valid sql login created in server?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 01:41:06

quote:
Originally posted by visakh16

Do you have a valid sql login created in server?

You'll only get that error if it's a valid account.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pvenkatesh2k4
Starting Member

6 Posts

Posted - 2008-06-13 : 01:45:23

thanks for ur quick reply. can explain how to do that? i cant find login in enterprise manager.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 01:47:12

It's under Security.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pvenkatesh2k4
Starting Member

6 Posts

Posted - 2008-06-13 : 01:47:57

yes i have created. but after that the password value is automatically changed to more characters other than what i entered initially.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 01:50:42

Ignore that. It wouldn't be a secure product if it showed you how many characters there were in a password. It would make it easier to hack it if someone knew that.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pvenkatesh2k4
Starting Member

6 Posts

Posted - 2008-06-13 : 01:53:51

actually i found only
following optins under security:
1)Authendication
2)Audit level
3)setup service account

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 02:00:22

You aren't looking in the correct place. Expand your server in Enterprise Manager, you'll see a bunch of folders. One of them is Security.

Where you are looking is when you go to the properties of the server, that's not where you want to be.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pvenkatesh2k4
Starting Member

6 Posts

Posted - 2008-06-13 : 02:10:22

thanks for ur quick reply.I got it ..... the problem is solved...thank u

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-13 : 02:12:29

You're welcome, glad you got it resolved.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources