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.
| Author |
Topic |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2006-10-05 : 08:25:03
|
| Hello all,Recently i have downloaded the sqlserver 2005 on xp operating systemNow i want to configure so that i can access the sql server by thesql authentication (by username and the password)Plz tell me the steps to configure the server so that i can access default northwind db.Waiting for your kind replySwati Jain |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-05 : 08:38:08
|
I assume you are using SQL 2005 Express edition. How are you going to access it - using .NET IDE, management studio or SQLCMD utility. Each of this has option to connect using Windows authentication.One more thing, SQL Express does not come with Northwind database by default. You will have to download it from Microsoft web site.http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Configuring sqlserver2005 in xp