Connection String for Windows Authentication

Posted 2010-07-07 03:02
by E A
in the SQL Server Forum

Hi,

I am able to connect to my database using the Connection string below. I am receiving the message "Failed to Open the Specified Database". I am not sure what can be wrong. I have tried two databases on the same server. Any help is appreciated.

myConnectionString = "Data Source=ABRAHIM-484C76E\\sqlexpress;Initial Catalog=AdventureWorks;Integrated Security=SSPI;";

Thank you

Reply 2010-07-07 03:03
by E A
in the SQL Server Forum

Sorry, I meant to UNABLE to connect in the first sentence above.

Reply 2010-08-03 12:23
by Max Wikström
in the SQL Server Forum

Hi
Did you solve this? If not, please provide some more code, not just the connection string.

Reply 2010-08-27 17:39
by Rajendra Sharna
in the SQL Server Forum

The server name specified by you is the same server in which your application is running? if not so then you must configure remote connections in SQL Surface area configuration and enable TCP/IP and named pipes option