Created a new alias with the SQL Server client network utility. With
the connection parameters, changed the server name to the IP address -
still no success.
Edited the Sql Server Network utility to use port 1433 to use port 0
(per another google discussion), still no success.
Any other ideas? The goal is to use the alias identically as how we
access the server name. Using the default instance of SQL Server.
Re: How to retrieve stored procedure error code in C#? ...Mark and William - thx for the replies, as they pointed me in the right ... > All Sql Server stored procedures have a return value parameter, ... > Please do not send email directly to this alias.... (microsoft.public.dotnet.framework.adonet)
Re: Merge Replication using ip address to distributor/publisher ... is no enterprize manager or client network utility.... I also read that alias to ip address can be programmed in subscriber ... register the Publisher in Client Network Utility." ... Looking for a SQL Server replication book?... (microsoft.public.sqlserver.replication)
change a named instance to default instance ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ... (microsoft.public.sqlserver.connect)
Re: Data Source connection fail ... In "SQL Server Client Network Utility", and in Alias tab I created a server alias with remote SQL Server IP address and port configured and "Network libraries" set to TCP/IP. ... I created a DTS Package and created a new "Microsoft OLE DB Connection for SQL Server". ... (microsoft.public.sqlserver.dts)
Re: SQL Server VPN problems / Help ... Create Alias to SQL server from your machine using CLIEN NETWORK UTILITY,... I want to use the remote SQL as ... (microsoft.public.sqlserver.server)
