Thread: SQL server...
View Single Post
  #2 (permalink)  
Old February 3rd, 2004, 06:26 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

How is your MSDN instance called? Are you sure it's called NetSDK?

Can you see your SQL Server using the Enterprise Manager (if you have it available)? That way, it's easy to see the instance name.

Also, you say you're using Integrated Security to log into the database. Do you mean you set your MSDN installation to Integrated only? If so, you'll need to modify your connection string. Right now you're using SQL Server Authentication because you're using a User ID. Take a look here for more info on a connection string that uses Integrated Security (Integrated Security needs to be set to SSPI, or alternatively, use Trusted_Connection=Yes.)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.