Help need reg Sql server 2005 installation

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

Transact-SQL (2005)

Help need reg Sql server 2005 installation

Author

Topic

Ambikaa
Starting Member

43 Posts

Posted - 2008-09-17 : 08:04:07

Hi,

I have used these three windows installer package to install sql server 2005

SqlServer2K5_BOL
SQLServer2005_SSMSEE
SQLServer2005_XMO

while installing i didn't get any phase to give sql server authentication, username and pwd set process

once i installed and i checked in sql server management studio express
it allows me to go only in windows authentication but not in sql server authentication as i said already while installation it didn't ask for sql serve authentication username and pwd ...

help me.

Regards,
Ambika

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-17 : 08:08:28

quote:
Originally posted by Ambikaa

Hi,

I have used these three windows installer package to install sql server 2005

SqlServer2K5_BOL
SQLServer2005_SSMSEE
SQLServer2005_XMO

while installing i didn't get any phase to give sql server authentication, username and pwd set process

once i installed and i checked in sql server management studio express
it allows me to go only in windows authentication but not in sql server authentication as i said already while installation it didn't ask for sql serve authentication username and pwd ...

help me.

Regards,
Ambika

Go to programs->Microsoft sql server 2005 ->configuration tools-> sql server surface configuration manger and set authentication mode to mixed mode.

Ambikaa
Starting Member

43 Posts

Posted - 2008-09-17 : 08:12:59

quote:
Originally posted by visakh16

quote:
Originally posted by Ambikaa

Hi,

I have used these three windows installer package to install sql server 2005

SqlServer2K5_BOL
SQLServer2005_SSMSEE
SQLServer2005_XMO

while installing i didn't get any phase to give sql server authentication, username and pwd set process

once i installed and i checked in sql server management studio express
it allows me to go only in windows authentication but not in sql server authentication as i said already while installation it didn't ask for sql serve authentication username and pwd ...

help me.

Regards,
Ambika

Go to programs->Microsoft sql server 2005 ->configuration tools-> sql server surface configuration manger and set authentication mode to mixed mode.

Hi,

I am not able to find the authentication mode in sql server surface configuration manager. could u please tell me in which option it is available?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-17 : 08:25:24

you can do it from sql management studio. see below

http://www.hostmysite.com/support/vps/windows/mixedmode/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources