database access

[Guest]

Given this 2 computers the first (ServDBSTest) running IIS and MS-SQL and the
second (SQLBACK) running only MS-SQL and with both databases having the user
“fleury†with “administrator†privileges, I can only access a database that
exists in the SAME computer as the web server (ServDBSTest) , if I try to use
the database in SQLBACK I’ll get the error message:

Cannot open database requested in login 'LION'. Login fails. Login failed
for user 'fleury'

The connection string I’m using is:

In WEB.CONFIG
<add key="DBS" value="server=sqlback; database=LION; user=fleury;
password=cct; "/>

In the offending procedure file:

Dim strConnection As String = ConfigurationSettings.AppSettings("DBS")
Dim objConnection As New SqlConnection(strConnection)
objConnection.Open()


Thanks
C.Fleury

 

[Kevin Spencer]

Try using the IP address instead of the machine name.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.