SQL server login problems - 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

General SQL Server Forums

New to SQL Server Programming

SQL server login problems

Author

Topic

soulidentities
Starting Member

3 Posts

Posted - 2009-02-18 : 22:35:10

Hi all
1st let me explain the senario.

1.I have installed Visual Stu 2005 (with sqlExpress)
2.I can finely use the sqlExpress dtabase northwind and manipulate it.
3.Now I have installed MS SQL Server 2005 from DVD.
During Installation I was not promted for custom user name and pass for login sql server 2005. Now I can still use sqlExpress database from that "SQL Server Management Studio". My Login name is "HOME\SQLEXPRESS" (Home is my computer name) and windows authentication (Default). It works fine.

My Question is why I have to use sqlExpress for login user, where i have installed MS SQL server 2005 for not using the sql express. I want to use Independent MS SQL Server 2005. By my user name n pass.
Notice that I have not asked for any user n pass during installation SQL server.

can anyone advice me whats wrong I am doing here or whats wrong I m thinking here.

PLz help me.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-19 : 00:07:26

You must not have installed it using mixed mode authentication. The default is Windows only.

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

Subscribe to my blog

soulidentities
Starting Member

3 Posts

Posted - 2009-02-19 : 00:38:58

YA thanks 4 your reply. But I have said u during install it didnt ask me anything like this.
Is there any solution!!!
Or U are advicing me to purchase another copy of SQL Server 2005!!!

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-19 : 10:59:04

Where did I say to purchase another copy of SQL Server? Don't put words into my mouth.

Like I already the default is Windows authentication only, so you would have had to specify mixed mode authentication in order to be prompted for the password for the sa account.

Why don't we start with the error that you are getting? You haven't even posted that yet!!!

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

Subscribe to my blog

soulidentities
Starting Member

3 Posts

Posted - 2009-02-20 : 00:26:06

Im sorry i didnt mean it.
I thing I found da solution..u r right...
Acually the mixed mode option shud be asked during installation.
I dont know why my intaller cd doesnt show these option. My copy may b limited vers.
I compare my copy with a installation video tutorial. They have another copy.
Evrything goes f9 mine. But when I want to choose component to install, it shows only 2 comp to install.
1. Client comp
2.Documentations, sample and sample database.

other many comp r disabled. I dont know why.
So I have to purchase another copy.

thanks. If you think still i m doing wrong pls advice.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources