Hello all.
I have one laptop and one workstation.
Both are running:
- Windows XP Professional SP2
- Microsoft SQL Server 2005 SP2 (SQLServer2005SP2-KB921896-x86-ENU)
- No Domain. Workgroup configuration. Same username and password on
both systems.
- Each SQL instance is named.
- TCP and NP remote connections enabled via Surface Area Configuration
Tool.
- SQL Server Browser Service is running.
- No firewall, Windows or otherwise on either machine.
- File and Print Sharing are working normally between machines.
- Windows NT and SQL Server events logs are error-free.
- NETSTAT -aod shows SQL Server Browser listening on Port 1434 (UDP).
- SQL Server Service configured to use dynamic port numbers.
Using SQL Server Managment Studio to connect from one machine to the
other, e.g. Laptop to Workstation, Workstation to Laptop.
In all cases, Error Message is:
TITLE: Connect to Server
--
Cannot connect to DELL-D800\SQL2K5.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
--
BUTTONS:
OK
--
I've tried Instance names, IP/Port combinations, e.g.
192.168.13.8,1080, Windows Authentication, SQL Server Authentication;
nothing works.
Anyone have any ideas?More info:
- Instances are not hidden.
- DNS resolves names completely. No other TCP/IP-related errors.
- Local connections are working.
Thanks all.
Showing posts with label professional. Show all posts
Showing posts with label professional. Show all posts
Thursday, March 8, 2012
Absolutely no luck connecting
Hello all.
I have one laptop and one workstation.
Both are running:
- Windows XP Professional SP2
- Microsoft SQL Server 2005 SP2 (SQLServer2005SP2-KB921896-x86-ENU)
- No Domain. Workgroup configuration. Same username and password on
both systems.
- Each SQL instance is named.
- TCP and NP remote connections enabled via Surface Area Configuration
Tool.
- SQL Server Browser Service is running.
- No firewall, Windows or otherwise on either machine.
- File and Print Sharing are working normally between machines.
- Windows NT and SQL Server events logs are error-free.
- NETSTAT -aod shows SQL Server Browser listening on Port 1434 (UDP).
- SQL Server Service configured to use dynamic port numbers.
Using SQL Server Managment Studio to connect from one machine to the
other, e.g. Laptop to Workstation, Workstation to Laptop.
In all cases, Error Message is:
TITLE: Connect to Server
Cannot connect to DELL-D800\SQL2K5.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=-1&LinkId=20476[/url]
BUTTONS:
OK
I've tried Instance names, IP/Port combinations, e.g.
192.168.13.8,1080, Windows Authentication, SQL Server Authentication;
nothing works.
Anyone have any ideas?
More info:
- Instances are not hidden.
- DNS resolves names completely. No other TCP/IP-related errors.
- Local connections are working.
Thanks all.
|||I am having the same problem connecting to a Vista Machine running SQL Express 2005 SP2 from an XP laptop. Like you, I have checked all the configuration settings and they seem correct. Remote connections are enabled.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
I have one laptop and one workstation.
Both are running:
- Windows XP Professional SP2
- Microsoft SQL Server 2005 SP2 (SQLServer2005SP2-KB921896-x86-ENU)
- No Domain. Workgroup configuration. Same username and password on
both systems.
- Each SQL instance is named.
- TCP and NP remote connections enabled via Surface Area Configuration
Tool.
- SQL Server Browser Service is running.
- No firewall, Windows or otherwise on either machine.
- File and Print Sharing are working normally between machines.
- Windows NT and SQL Server events logs are error-free.
- NETSTAT -aod shows SQL Server Browser listening on Port 1434 (UDP).
- SQL Server Service configured to use dynamic port numbers.
Using SQL Server Managment Studio to connect from one machine to the
other, e.g. Laptop to Workstation, Workstation to Laptop.
In all cases, Error Message is:
TITLE: Connect to Server
Cannot connect to DELL-D800\SQL2K5.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=-1&LinkId=20476[/url]
BUTTONS:
OK
I've tried Instance names, IP/Port combinations, e.g.
192.168.13.8,1080, Windows Authentication, SQL Server Authentication;
nothing works.
Anyone have any ideas?
More info:
- Instances are not hidden.
- DNS resolves names completely. No other TCP/IP-related errors.
- Local connections are working.
Thanks all.
|||I am having the same problem connecting to a Vista Machine running SQL Express 2005 SP2 from an XP laptop. Like you, I have checked all the configuration settings and they seem correct. Remote connections are enabled.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Absolute path information is required. (mscorlib)
Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.
I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.
|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>
|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.
I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.
|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>
|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
Absolute path information is required. (mscorlib)
Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> > Installed SQL2005 Advisor on a XP Professional machine.
> >
> > I get this message when I launch the program.
> >
> > Absolute path information is required. (mscorlib)
> >
> > Please help, I need to resolve it.
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
--
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>> I did a quick search and could not find that exact error msg but it looks
>> like a problem with the .net framework install. You might try
>> uninstalling
>> the .net framework and reinstalling it. Make sure you are using the
>> latest
>> version of the Advisor tool and the latest .net2.0 framework, not any
>> Betas.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in
>> message
>> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>> > Installed SQL2005 Advisor on a XP Professional machine.
>> >
>> > I get this message when I launch the program.
>> >
>> > Absolute path information is required. (mscorlib)
>> >
>> > Please help, I need to resolve it.
>>
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the latest
> version of the Advisor tool and the latest .net2.0 framework, not any Betas.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> > Installed SQL2005 Advisor on a XP Professional machine.
> >
> > I get this message when I launch the program.
> >
> > Absolute path information is required. (mscorlib)
> >
> > Please help, I need to resolve it.
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
--
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>> I did a quick search and could not find that exact error msg but it looks
>> like a problem with the .net framework install. You might try
>> uninstalling
>> the .net framework and reinstalling it. Make sure you are using the
>> latest
>> version of the Advisor tool and the latest .net2.0 framework, not any
>> Betas.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in
>> message
>> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>> > Installed SQL2005 Advisor on a XP Professional machine.
>> >
>> > I get this message when I launch the program.
>> >
>> > Absolute path information is required. (mscorlib)
>> >
>> > Please help, I need to resolve it.
>>
Absolute path information is required. (mscorlib)
Installed SQL2005 Advisor on a XP Professional machine.
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the lates
t
> version of the Advisor tool and the latest .net2.0 framework, not any Beta
s.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in messag
e
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>
I get this message when I launch the program.
Absolute path information is required. (mscorlib)
Please help, I need to resolve it.I did a quick search and could not find that exact error msg but it looks
like a problem with the .net framework install. You might try uninstalling
the .net framework and reinstalling it. Make sure you are using the latest
version of the Advisor tool and the latest .net2.0 framework, not any Betas.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
> Installed SQL2005 Advisor on a XP Professional machine.
> I get this message when I launch the program.
> Absolute path information is required. (mscorlib)
> Please help, I need to resolve it.|||Thank you, I did the same thing as well. I am running the most current
versions of both. Uninstalled netframework and reinstalled. Same issue.
If anyone else has a hine please feel free.
"Andrew J. Kelly" wrote:
> I did a quick search and could not find that exact error msg but it looks
> like a problem with the .net framework install. You might try uninstalling
> the .net framework and reinstalling it. Make sure you are using the lates
t
> version of the Advisor tool and the latest .net2.0 framework, not any Beta
s.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in messag
e
> news:91026A05-8C40-4651-A165-FA9D9A5D12B1@.microsoft.com...
>
>|||Sounds like a bug then. You may need to give MS PSS a call. If it is a bug
they will refund your money. But otherwise it will cost about $225.
Andrew J. Kelly SQL MVP
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:BD75850A-7A5D-461D-BCF8-E1B4FBCD66FE@.microsoft.com...[vbcol=seagreen]
> Thank you, I did the same thing as well. I am running the most current
> versions of both. Uninstalled netframework and reinstalled. Same issue.
> If anyone else has a hine please feel free.
> "Andrew J. Kelly" wrote:
>
Subscribe to:
Comments (Atom)