trusted connection problem - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

trusted connection problem

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-12 : 23:02:56

mark writes "Dear Sir or Madam,

I work with ASP with SQL server 2000, but I can not connect SQL Server,I always get error like this
"Cannot open database requested in login 'yonet'. Login fails"

I ask system administrator,he tell me the SQL server use NT authentication, so I do not have access account name and password.

Please tell me how to deal with the problem,I do not know if ASP can work with SQL Server NT authentication.

Thanks a lot.

Mark"

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-03-12 : 23:44:12

as far as I'm aware (and someone may know more) you'll need to hard code into your connection string your user name and password and set trusted connection to no

eg

Set Cnxn = Server.CreateObject("ADODB.Connection")
Cnxn.Open "Provider=sqloledb;Server=MyServer;Database=MyDB;Trusted_Connection=no;UID=Me;Pwd=w0t3v3r"

or
Have your Sysadmin create a specific "asp user" account with a known password and log in using that account
eg

Set Cnxn = Server.CreateObject("ADODB.Connection")
Cnxn.Open "Provider=sqloledb;Server=MyServer;Database=MyDB;Trusted_Connection=no;UID=ASPUser;Pwd=w0t3v3r"

Cheers

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources