ConnectionString Error

  • Thread starter Thread starter wdewebserver
  • Start date Start date
W

wdewebserver

Hi All

I am buffled by someone not being able to connect to a SQL 2000 instance
using C#. The connection string is as follows,

<add key="ConfigString" value="Persist Security Info=False;Integrated
Security=SSPI;database=SQLApp;server=SAM-NUB10\INSTANCE1"></add>

The Server name is SAM-NUB10 and the instance name is INSTANCE1. The
application use the tables in this instance. Can someone shed some light
where the glitch might be?

Thanks in advance
 
The ConnectionString looks OK, if the server (and instance) name and
database name are correct. So what is the exact error message you get? It is
most likely that you have SQL login/access permission problem. Does the user
account (obviously, you use Windows security for SQL Server access) that
runs the app (Windows app or web app?) has the permission to get into SQL
Server and access the said database? Or do you correclt set up the SQL
Server login that maps to corresponding Windows user account and then give
proper permissions to that SQL Server login?
 
Back
Top