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

Using XP Pro as ms sql 2005 server

Can I install ms sql 2005 in an XP Pro box and access the databases remotely with the Server Management Studio?
0
robrodp
Asked:
robrodp
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
Yes, I have a box used the same way at home that several pc connect to via Management Studio.
0
 
robrodpAuthor Commented:
What do I have to configure to do it.

It connects well from de server but I cannot connect via a PC that is on the same network. I have defined a SQL login, enabled TCP/IP, what do I have to change or enable to get it to coonect to the remote server?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
- you first make sure that you can ping that server
- Open SQL serve managerment studio in the remote machine when prompted for the user credentials, put the servername (IP  will be better , now if you installed as  a named instance you need to put IP\instanceName  or serverName\InstanceName ) , enter the username and passsword
- if you are getting something similar to "Remote connection error " , read my post here
http://sequelserver.blogspot.com/2007/06/under-default-settings-sql-server-does.html

aneesh
0
 
SQL_SERVER_DBACommented:
IP or ServerName, they both work for be sure to allow remote connections from sql server configuration
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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