424,294 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,294 IT Pros & Developers. It's quick & easy.

Connectionstring to SQL Server on Local Server

P: n/a
When I am attempting to connect to SQL Server 2000 on my local server, I get the following error:

"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"

My connection string is as follows:

string strCnn = "server=fredflintstone;uid=sa;pwd='';database=DBPa ss"

For my SQL Server account I am using Local Windows Authentication, so I don't have a password. I also tried using server=local as well as different uid's. All have the same result. Should I set up SQL Server 2000 to use a different userID and password instead of window's authentication? If I do, is the connection string going to be similar?

Thanks for any input on the subject.

BGuy
Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I would bet that you only have Windows Authentication
turned on for your SQL Server Service. Either try the
Integrated Security=SSPI in your connection string or
reconfigure your security on the SQL Server Service.
-----Original Message-----
When I am attempting to connect to SQL Server 2000 on my local server, I get the following error:
"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"
My connection string is as follows:

string strCnn = "server=fredflintstone;uid=sa;pwd='';database=DBPa ss"
For my SQL Server account I am using Local Windows Authentication, so I don't have a password. I also tried
using server=local as well as different uid's. All have
the same result. Should I set up SQL Server 2000 to use a
different userID and password instead of window's
authentication? If I do, is the connection string going
to be similar?
Thanks for any input on the subject.

BGuy
.

Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.