May 1, 2006 at 3:26 pm
Two servers, one for web server, another one is database server. Cross-connected under same workgroup.
I can access the database on the database server via SQL Server Enterprise Manager on the web server . For some reason, we can not access the database through my .Net program.
the connection string is:
"Data Source=10.0.1.218,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
It can not connect to the database server.
internal IP addresses are 10.0.1.218 (web) and 10.0.1.178 (db)
THe database authentication is using Windows and SQL server mixed.
Both servers are running Windows 2003 Server and SQL server 2000.
Any help will be greatly appreicated!
May 4, 2006 at 8:53 am
Have you tired using the server name instead of the ip 10.0.1.218 ?
May 4, 2006 at 12:12 pm
I have tried it. But not working either
May 6, 2006 at 12:45 am
I think you have to configure your Sql Server.If yor application is ASP.NET give ASP.NET enough access right to your database.
May 6, 2006 at 12:45 am
I think you have to configure your Sql Server.If yor application is ASP.NET give ASP.NET enough access right to your database.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply