Connection String? Don't understand what's wrong

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

Development Tools

ASP.NET

Connection String? Don't understand what's wrong

Author

Topic

ddaurio
Starting Member

5 Posts

Posted - 2009-07-28 : 12:47:25

Doing a simple test program to make sure I can connect. I have two connections: one to local server and one to hosted web server. When I run the application locally, it connects. If I publish it and run it, it won't connect.



<connectionStrings>
 <add name="WebConnectionString" connectionString="Data Source=xxxx; Initial Catalog=wotest; User ID=xxxx; Password=xxxx;" providerName="System.Data.SqlClient"/>
 <add name="localConnectionString" connectionString="Data Source=DBSERVER\DBRCO;Initial Catalog=ImportWoSQL;Persist Security Info=True;User ID=xxx;Password=xxxx"
        providerName="System.Data.SqlClient" />    
</connectionStrings>

_____________
DDaurio

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-07-28 : 13:50:55

Where's the error?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-07-29 : 07:42:46

is this sql express ? DBSERVER\DBRCO

paste your error message here

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources