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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2008-06-02 : 02:26:57
|
| Hi,i have a web server1 and database server1 working fine. i configured another webserver2 to access the database server1 to have as a backup for web server1. i configured IIs2 same as IIS1 configured the application pool to have the domain account which have already permission on the database server1 (IIS is using local system account same as webserver1). the website will open on the local webserver2 but when connecting from the client it will give this error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. we are using windows authentication to connectall users are already configured on the database server1 nothing changed on the databasei tried all options in the application pool but all same result.am stuck please advice and help me |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 00:31:34
|
| What's connection string in your app? |
 |
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2008-06-03 : 04:19:30
|
| <add key="ConnectionString" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=EFILING;Data Source=RPDHO07;"/> |
|
|
|
metaraja
Starting Member
3 Posts |
Posted - 2008-06-03 : 04:57:42
|
| Try this one...<add name="MyConn" providerName="System.Data.SqlClient" connectionString="SERVER=webappsdev3;UID=HelpDesk;PWD=rufus;DATABASE=AMS;Pooling=True;Max Pool Size=100;Min Pool Size=10"/>Raja |
|
|
|
binumv
Starting Member
7 Posts |
Posted - 2008-06-03 : 05:22:03
|
| disable firewall or give exception to port 1433 in your remote server |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-06-03 : 06:16:37
|
| http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2008-06-04 : 08:23:39
|
| - Mr. Mataraja what is this connection string ?? i never saw like this b4 where to specify the database name or catalog name !!- firewal is disabled |
|
|
|
|
|
|
SQL Server does not exist or access denied!!