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 |
|
jrdatla
Yak Posting Veteran
51 Posts |
 Posted - 2001-01-05 : 21:58:53
|
| Hi allWe have a Sql server with Sql server authentication and we are accessing the database thro ASP Pages using the Username and password.Now, The Sql server Authentication has been changed to Windows Authentication.What should i give in the ASP pages to log in to the SQL Server database using the Windows authentication.I gave it as <ConnectionString>Provider=SQLOLEDB.1;Persist Security Info=True;User ID=raju;Password=password;Data Source=Rajoo;Initial Catalog=rajoo</ConnectionString><DatabaseName>rajoo</DatabaseName>where raju is my Windows username and password is the password.It gives me an error as Error Type:Microsoft OLE DB Provider for SQL Server (0x80004005)Login failed for user 'raju'. Reason: Not associated with a trusted SQL Server connection.Can anyone give me a solution to the above said.ThanksRaju Datla |
|
|
|
|
|
Sql server using Windows Authentication