June 14, 2005 at 7:26 am
Hello Guys!
I'm working with named instances:
- PC1(MSDE 2000) => CLAUDIA\MYMSDE
- PC2(SQL SERVER Developer Ed. 2000) => FRC-GIIT-CIRKUS\MYSQL
Both pc's are in the same domain!
In both i'm using mixed authentication mode: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\myinstance\MSSQLServer LoginMode=0
In both pc's, the server configuration is:
- through csvrnetcn.exe, I made the enable of “Named Pipes” and “TCP/IP" (port 1433).
In both pc's, the client configuration is:
- through cliconfg.exe, I made the enable of “Named Pipes” and “TCP/IP" (port 1433).
In PC1 i can see the named instance of PC2:
C:\Documents and Settings\claudia.rego>osql -L
Servers:
(local)
FRC-GIIT-CIRKUS\MYSQL
And i can connect to PC2:
With Windows Authentication:
C:\Documents and Settings\claudia.rego>osql -E -S FRC-GIIT-CIRKUS\MYSQL
1> QUIT
With sql Ser ver Authentication:
C:\Documents and Settings\claudia.rego>osql -S FRC-GIIT-CIRKUS\MYSQL -Usa
Password:
1> QUIT
In PC2 I can not see the named instance of PC1:
C:\Documents and Settings\claudia.rego>osql -L
Servers:
CLAUDIA
FRC-GIIT-CIRKUS\MYSQL
And i can not connect:
C:\Documents and Settings\claudia.rego>osql -E -S CLAUDIA\MYMSDE
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen(Connect())
C:\Documents and Settings\claudia.rego>osql -S FRC-GIIT-CIRKUS\MYSQL -Usa
Password:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen(Connect())
Since clients with MDAC 2.6 identify servers by ServerName\InstanceName, and clients with MDAC 2.5 ca not recognize InstanceName. I install in both pc's MDAC2.6. And i specify port 1433. But this not resolve my problem!!!
WHY????
Thanks a lot
Obrigada, CLáudia
Cláudia Rego
www.footballbesttips.com
June 14, 2005 at 7:54 am
Port 1433 is used by the DEFAULT instance of SQL and not the named instance. Try checking the Dynamically determine port and try again. You will not be able to hardcode the port number because it can (and probably will) change every reboot for the named instances
Good Hunting!
AJ Ahrens
webmaster@kritter.net
June 14, 2005 at 7:54 am
Try (after edit)
-S "FRC-GIIT-CIRKUS\MYSQL"
Using "-" in server names can be a pain..
I thing the osql is parsing to osql -S FRC..
June 14, 2005 at 8:04 am
You can hardcode port numbers.
The first start up wil determine the port number.
For example, in "Security Account Delegation" scenarios (see BOL) you have to use the port number to with "setspn". If it changed, this wouldn't work.
Edit: Because we use SAD, we fix our ports at install time.
Though none our non-default instances (3 of 30) have ever changed port number, despite what BOL says.
It could occur maybe if the port was now being used by another app.
June 15, 2005 at 4:16 am
Sorry, I've misunderstood your original post.
Can you set up an ODBC connection?
I'll post more in a minute
June 15, 2005 at 4:28 am
What OS do you have?
If you have XP SP on PC1 and it's windows firewall is enabled, this may block connections to your SQL instance on PC1
June 15, 2005 at 4:37 am
ODBC between PC1 and PC2?
On both i have Windows XP Pro but i diasable both firewalls.
Cláudia Rego
www.footballbesttips.com
June 15, 2005 at 4:51 am
On PC2, have you tried osql -E -S "FRC-GIIT-CIRKUS\MYSQL"
June 15, 2005 at 4:58 am
I works!
the problem is that i can see CLAUDIA\MYMSDE (named instance of PC1) in PC2. Only appears CLAUDIA and FRC-GIIT-CIRKUS\MYSQL (named instance of PC2)
Cláudia Rego
www.footballbesttips.com
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply