Member Avatar for carelvos

Hi Guys,

I have a problem connecting to a SQL Server from Windows 7 - this particular server I can only connect to by using the named instance from Win XP - I can connect to other servers that does not require you to connect to the named instance eg:

I can connect to SERVER1 with XP and Win7 64bit

the other server I can connect to SERVER2\sqlexpress with XP but not win7 64bit.

I did google around, and got some suggestion that you must change the connect string if you connect from a 64bit O/S - but I don't get any specific information.

Any help would be greatly appreciated...

  • 2 Contributors
  • 5 Replies
  • 191 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Ramy Mahrous

Recommended Answers

All 5 Replies

Member Avatar for Ramy Mahrous

Can you please try SQL authentication not Windows authentication, it may be problem of provisioning

Member Avatar for carelvos

I tried everything - everything is exactly like on XP box and Win7 32bit box - the only thing different is that this is Win7 64bit.

Member Avatar for Ramy Mahrous

Try to install SQLServer2005_SSMSEE_x64 again from CMD (Run as administrator) try again.. I have exactly the same environment and everything wors pretty good...

Member Avatar for carelvos

Do you connect to a named instance?

This 64bit box can connect to other servers, with the following connection string:

Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=192.168.100.1;Initial Catalog=Tupperware Distributor System;User ID=sa;Password=pass;

It just cannot connect to this server, with the named instance of "dina"

Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=192.168.101.1\dina;Initial Catalog=Tupperware Distributor System;User ID=sa;Password=pass;

But the XP boxes and Win7 32bit connect to it without problems, and I don't know why this particular server has to be connected to a named instance (I did not set up the servers)

Thanks for your time so far...

Edited by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
Member Avatar for Ramy Mahrous

In such situation I don't know specific reason for that...
Try instead of Data Source=192.168.101.1\dina Data Source={server name}\dina
make sure sql server instance {dina} allows remote connections with named pipes\TCP

Develop an application connects to this server on 64 and catch the exception and detailed exception then send them here..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.