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
 problem at establishing sqlserver 2005 connection

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2006-10-14 : 00:50:06
hi,
i am using sql server 2005 as back end to my asp.net application. for my apllication i created database named lib in sql server 2005 instead of using system databases, i am facing problem at establishing connection b/w asp.net application to sql server2005.i had written connection in web.config file as:
<connectionStrings>
<add name="Intranet" connectionString="DataSource=(local)\SQLEXPRESS;integrated security = SSPI; DataBase = lib"/>
</connectionStrings>

it is establishing connection successfully. but it is throwing error as : login failed to lib. i didn't put any ids and pwds to my database or to sql serevr.
how can i overcome this problem.
thanx in advance,
rammmohan

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-14 : 02:17:43
try some of the Connectionstrings mention over here.
http://www.connectionstrings.com/

Are you Able to login via SSMS?


Chirag

http://chirikworld.blogspot.com/
Go to Top of Page
   

- Advertisement -