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 2005 Forums
 SQL Server Administration (2005)
 Connecting to SQL Server

Author  Topic 

deco10
Starting Member

28 Posts

Posted - 2010-03-19 : 12:43:42
Hi,
I recently transferred my work from my desktop to the server. I'm experiencing a problem with my connection strings. I was using sql express 2008 and now I am using SQL server 2005. I cannot get my application to connect to the sql server. I can connect to it with Management Tools though. It seems like I have tried every possible combination of server names / sql engines with no luck. I would expect localhost or localhost\mssqlserver to work, but I'm still getting not found/not accessible errors when the webserver tries to connect to the sql server.

This is from my web.config file, hopefully somebody can advise.

<add name="aspnetdbConnectionString" connectionString="Data Source=MARM\MSSQLSERVER;Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient" />

Any help you can provide me would be so greatly appreciated. Thanks!

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-19 : 13:00:00
is MARM the name of the server?
Go to Top of Page

deco10
Starting Member

28 Posts

Posted - 2010-03-19 : 13:22:53
The error occurs on a line where I use the Memberhip class, so I think I need to investigate that. Thanks for the response :)
Go to Top of Page
   

- Advertisement -