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
 Trying to connect SQL Server database through...

Author  Topic 

RichardBone
Starting Member

29 Posts

Posted - 2006-10-17 : 22:16:30
VB.NET. I'm getting this error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I don't have a username and a password setup for my server connection.
I tried changing the Security properties to Windows & SQL and Windows
authenciation and I'm still getting this error. Am I suppose to set up a username and password for my server? If so how? Thanks

Also a quick side question, how do I make the primary key auto increment through Enterprise Manager?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-17 : 22:31:43
Take a look here http://www.connectionstrings.com/
Did you set Integrated Security=SSPI ?

"how do I make the primary key auto increment through Enterprise Manager?"
set identity = Yes


KH

Go to Top of Page
   

- Advertisement -