problems registering servers using sql authentication

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

problems registering servers using sql authentication

Postby dbaman6 » Wed Mar 19, 2008 10:08 pm

We use sql authentication with sql 2000 databases. I can remote desktop to a server using either the name or IP address to find a server. I can also use query analyzer with either the servername or IP address and both connect directly to the database. I think my DNS is working.

When I try to add a server though using either the name or IP address, I get a connection error.

I have tried changing the connection properties from default to tcp/ip and named pipes but nothing connects. Any ideas?
dbaman6
 
Posts: 4
Joined: Tue Apr 18, 2006 7:15 pm

Postby Ben Pinchen » Thu Mar 20, 2008 7:42 pm

What is the exact error message that you're getting? Could you try explicitly stating the port that you're using to connect to SQL Server and if that doesn't work try forcing tcp/ip as well e.g.

SERVERNAME,1234
SERVERNAME\\INSTANCENAME,1234
TCP:SERVERNAME\\INSTANCENAME,1234
Ben Pinchen
 
Posts: 157
Joined: Thu Dec 28, 2006 1:21 pm
Location: Red Gate

Postby dbaman6 » Fri Mar 21, 2008 5:05 pm

Still no luck with any of the three options.

One thing I noticed though, the computer I am trying to connect to is part of a workgroup. In my enterprise manager, when I try to register a server, the database server I am trying to connect to shows up. In SQL Multi Script, the db server does not show up. Only the database servers in my domain show up in the selection list. Why wouldn't any database servers in the workgroup WORKGROUP show up in the selection list?
dbaman6
 
Posts: 4
Joined: Tue Apr 18, 2006 7:15 pm


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests