connection string for another sql server on lan

[Guest]

Hi,

Have a quick question. Having a problem connecting from the IIS server
(windows 2000 sp3) which hosts the asp.net application to retrieve data from
an SQL server (windows nt 4, sql 7). The error keeps coming up SQL server
does not exist or access denied. I've checked the permissions, etc and it
seems to be fine. I used query analyzer from the windows 2000 (has
enterprise connectivity tools) machine and it works. Here is the connection:

protected string myAdminConnectionString = "Provider=dbmssocn;Data
Source=PIMZZ00;Initial Catalog=PIM;User ID=temp;Password=temp";

also tried
protected string myAdminConnectionString = "Data Source=192.168.1.2;Initial
Catalog=PIM;User ID=temp;Password=temp";

I tried installing SQL server on the 2000 machine (had an extra license) but
MMC is getting an error. Has anyone seen this error before?
Application popup: mmc - Application Error: The instructions at 0x77abfcf5
referenced memory at 0x0000000" The memory could not be read.

In the event viewer it came up with:
The description for Event ID 19011 in Source (MSSQLServer) cannot be found.
The local computer may not have the necessary registry information or message
DLL files to display messages from a remote computer. The following
information is part of the event (SpnRegister): Error 1355.

Thanks - Zack

 

[DraguVaso]

Hope this helps:

http://www.connectionstrings.com