Can't connect to a SQL 2K instance

[ddrake]

I just recently created an instance on my SQL 2K db box to accomodate our webmaster who needs his data to be separate from the default instance. Now he cannot connect to that instance. We're using dreamweaver btw. In the connection documents, for the server name, used to have it as remedydev, uid=...... The instance is named JACK so we changed the connection document to remedydev\jack, uid=........
Anybody else have similar issues or anything? Thanks!

 

[gmmastros]

Each instance of sql server will have a different port. On the machine hosting the database, you will need to open the port for that instance.

Click start -> run
Type svrnetcn

At the top of the window, choose the named instance.
In the 'enabled protocols' list, click tcp/ip, and then click the properties button. You will see the port used by SQL Server for that instance.

Change the firewall to open that port.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLBill]

And make sure they have a login on the new instance.

-SQLBill

Posting advice: FAQ481-4875

 

[ddrake]

Thanks! Didn't know about that utility. Very cool! He's still having an issue connecting, but we're closer!! Here's a generic version of the string used to define the connection:

MM_connMyConnection_STRING = "Provider=SQLOLEDB;Data Source=MyServer\InstanceName:2116;Initial Catalog=my_table;uid=gooduserid;pwd=yadayadayada;

 

[gmmastros]

I believe the colon in the datasource should be a comma.

Connect via an IP address:

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom