• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

sql 2005 - access sql server from web server, n/a, n/a

How do you set up an icon that opens sql2005 on a web server that is physically connected to the sql server?  We switched out sql servers and now my sql2005 icon on my web server doesn't work any more.  The target was "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe".
0
dcass
Asked:
dcass
  • 3
  • 3
  • 2
1 Solution
 
techleetCommented:
right-click the desktop,  new > shortcut... paste "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe" in and click next, finish...?
0
 
dcassAuthor Commented:
I get an error that says that SQL may not accept remote connections.
I looked at all the properties, the Network Configuration (protocols) and Native Client Configuration (Client Protocols & Aliases) - just don't see anything there to set that.
Do the servers have to be in the same Workgroup?  Is there anything else I should check?
0
 
dcassAuthor Commented:
Anyone got any help to give here?  Any ideas?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
techleetCommented:
They do not have to be in the same workgroup.  That's a strange error.... make sure you don't have Windows Firewall turned on (or if you do, make sure tcp/1433 is open)
0
 
CragCommented:
Have you enabled Remote Connections in the Surface Area Configuration program? They are disabled by default.
0
 
techleetCommented:
Crag:  Would it give a remote connection error if you're trying to connect to localhost?
0
 
CragCommented:
It all depends what your connection string looked like.
Do you have localhost for the server or a servername /ip address?
Do you get an error in the SQL Server error logs or the Windows event viewer?
0
 
dcassAuthor Commented:
Solved finally.
The two servers needed to be in the same workgroup, plus since I had two installations of sql on the sql server (sql2000 and sql2005 express), I had to make the connection string  (server name) SQLServerComputerName\SQLEXPRESS.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now