Client utility asks for the Server Alias name, and the server name.
If the computer-name is Location1, and the SQL-Server instance
name = BOB, and say the ip-adress is 1.2.3.4
Then,
Server Alias Name would = Location1\BOB
Server Name would = 1.2.3.4\BOB
Is this correct?
Yes!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" wrote:
> Client utility asks for the Server Alias name, and the server name.
> If the computer-name is Location1, and the SQL-Server instance
> name = BOB, and say the ip-adress is 1.2.3.4
> Then,
> Server Alias Name would = Location1\BOB
> Server Name would = 1.2.3.4\BOB
> Is this correct?
>
>
|||I am having trouble connecting:
server doesn't exist or access denied
ConnectionOpen (connect() )
I can connect via XP remote desktop to the public ip 207.x.x.x .
In doing so and checking tcp/ip properties, I see that the setting is NOT to
obtain an IP automatically, rather it is "use this ip address". And the
local address is 192.x.x.x
How does this effect my connection setup?
thank you,
bob
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:9F58DE4A-569D-4561-8252-DABFDE6AFC99@.microsoft.com...[vbcol=seagreen]
> Yes!
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Robert A. DiFrancesco" wrote:
instance[vbcol=seagreen]
Location1\BOB[vbcol=seagreen]
Showing posts with label alias. Show all posts
Showing posts with label alias. Show all posts
Friday, February 24, 2012
Thursday, February 16, 2012
Client Network Utility cannot create alias for VPN SQL server connection?
I am trying to connect two SQL servers in different non-trusted domains.
SQLServer11 in Domain A and SQLServer22 in domain B. This is through a VPN
connection. Domain A has the VPN server. On SQLServer22 I could ping
SQLServer11.mydomain.local at IP address 192.168.100.50. On SQLServer22 I
use the client network utility to create an alias for SQLServer11 as
follows:
Network Libraries: TCP/IP
Server name: 192.168.100.50
Port No: 1433
Server alias: SQLServer11
Then I registered the new SQLServer11 in enterprise manager. But I keep
getting the error message "SQL server does not exist or access
denied.ConnectionOpen(Connect())" .
Why is this so? And how can I rectify the problem'If you use ping -a <ip address> does it bring back the correct name for the
server? If you ping SQLServer11 does it return the proper ip address? If
you are using NT authentication to register then try SQL authentication..
Verify that it is using port 1433 and that SQL Server is actually listening
on TCP/IP.
Rand
This posting is provided "as is" with no warranties and confers no rights.
SQLServer11 in Domain A and SQLServer22 in domain B. This is through a VPN
connection. Domain A has the VPN server. On SQLServer22 I could ping
SQLServer11.mydomain.local at IP address 192.168.100.50. On SQLServer22 I
use the client network utility to create an alias for SQLServer11 as
follows:
Network Libraries: TCP/IP
Server name: 192.168.100.50
Port No: 1433
Server alias: SQLServer11
Then I registered the new SQLServer11 in enterprise manager. But I keep
getting the error message "SQL server does not exist or access
denied.ConnectionOpen(Connect())" .
Why is this so? And how can I rectify the problem'If you use ping -a <ip address> does it bring back the correct name for the
server? If you ping SQLServer11 does it return the proper ip address? If
you are using NT authentication to register then try SQL authentication..
Verify that it is using port 1433 and that SQL Server is actually listening
on TCP/IP.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Client Network Utility - tcp/ip
what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?
You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?
You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Client Network Utility - tcp/ip
what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Client Network Utility
Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
----
--
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
--
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
----
--
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
--
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the serv
ice using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server fro
m my laptop, but still no luck !|||I received a reply from my server when i pinged it.
ice using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server fro
m my laptop, but still no luck !|||I received a reply from my server when i pinged it.
Client Network Utility
Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the service using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?
You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?
|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck !
|||I received a reply from my server when i pinged it.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?
You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?
|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck !
|||I received a reply from my server when i pinged it.
Client Network Utility
Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
--
----
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
--
----
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the service using the Service Manager
I have already created an alias using Client Network Utility - TCPIP
But every time i select the service i get The network path is not found
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck|||I received a reply from my server when i pinged it
I have already created an alias using Client Network Utility - TCPIP
But every time i select the service i get The network path is not found
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck|||I received a reply from my server when i pinged it
Sunday, February 12, 2012
Client alias on 64bit server
We have just upgraded a 32bit server to 64bit Windows 2003, we had client
alias working correctly before when os was 32bit but now we have gone to
64bit i can't get any aliases to work.
I've tried configuring exactly the same alias on a 32bit machine and that
works but if the server is 64bit then no joy, even if try to create an alias
to the local 64but machine.
Any help would be gratefully appreciated.
Same problem here with XP 64. I've tried both 2000 and 2005 with the same
problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
worked (setting the port on the second screen).
"Adam Shepherd" <Adam Shepherd@.discussions.microsoft.com> wrote in message
news:95F13D92-FBC9-4FD9-8C0B-AB4D3EF8370F@.microsoft.com...
> We have just upgraded a 32bit server to 64bit Windows 2003, we had client
> alias working correctly before when os was 32bit but now we have gone to
> 64bit i can't get any aliases to work.
> I've tried configuring exactly the same alias on a 32bit machine and that
> works but if the server is 64bit then no joy, even if try to create an
> alias
> to the local 64but machine.
> Any help would be gratefully appreciated.
|||I've done a bit of playing around and i think what's happening is that the
alias is being written to the 32bit registry but sql server is trying to read
from the 64bit registry. If i create an entry in the 64bit registry then
alias works ok. The registry keys are:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ MSSQLServer\Client\ConnectTo
and:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Looks like an issue with SQL Server, but if the key is in boht locations
then aliases work.
hope that helps,
Adam
"Scott Wallace" wrote:
> Same problem here with XP 64. I've tried both 2000 and 2005 with the same
> problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
> worked (setting the port on the second screen).
>
> "Adam Shepherd" <Adam Shepherd@.discussions.microsoft.com> wrote in message
> news:95F13D92-FBC9-4FD9-8C0B-AB4D3EF8370F@.microsoft.com...
>
>
alias working correctly before when os was 32bit but now we have gone to
64bit i can't get any aliases to work.
I've tried configuring exactly the same alias on a 32bit machine and that
works but if the server is 64bit then no joy, even if try to create an alias
to the local 64but machine.
Any help would be gratefully appreciated.
Same problem here with XP 64. I've tried both 2000 and 2005 with the same
problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
worked (setting the port on the second screen).
"Adam Shepherd" <Adam Shepherd@.discussions.microsoft.com> wrote in message
news:95F13D92-FBC9-4FD9-8C0B-AB4D3EF8370F@.microsoft.com...
> We have just upgraded a 32bit server to 64bit Windows 2003, we had client
> alias working correctly before when os was 32bit but now we have gone to
> 64bit i can't get any aliases to work.
> I've tried configuring exactly the same alias on a 32bit machine and that
> works but if the server is 64bit then no joy, even if try to create an
> alias
> to the local 64but machine.
> Any help would be gratefully appreciated.
|||I've done a bit of playing around and i think what's happening is that the
alias is being written to the 32bit registry but sql server is trying to read
from the 64bit registry. If i create an entry in the 64bit registry then
alias works ok. The registry keys are:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ MSSQLServer\Client\ConnectTo
and:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Looks like an issue with SQL Server, but if the key is in boht locations
then aliases work.
hope that helps,
Adam
"Scott Wallace" wrote:
> Same problem here with XP 64. I've tried both 2000 and 2005 with the same
> problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
> worked (setting the port on the second screen).
>
> "Adam Shepherd" <Adam Shepherd@.discussions.microsoft.com> wrote in message
> news:95F13D92-FBC9-4FD9-8C0B-AB4D3EF8370F@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)