Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
R
Constraint Violating Yak Guru
328 Posts |
 Posted - 2008-12-02 : 05:55:55
|
Hi there. I'm working with SQL 2005 Developer on my local machine. I also have a laptop with the same software on, and I'd like the laptop to be able to connect to my local pc using Management Studio so that I can copy a database from one machine to the other.Currently I get an error regarding allowing remote connections. I'm not familiar with setting up this in SQL and don't want to allow remote PC's from outside my intranet to be able to connect, for security reasons!Can anyone explain how I might be able to just allow a connection from the laptop to my main machine??Thanks in advance.  |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-12-02 : 14:28:26
|
| Some editions of SQL Server install with no network protocols enabled by default. Open up SQL Server configuration manager on the SQL Server machine, and check to see what is enabled for protocols. Normally you would want TCP/IP enabled. if the machines can not even use WINS to resolve names, you can connect by the IP address of the other machine.You would also need to connect with a SQL Server login, since it is unlikely you have a Domain Controller on your home network. by default SQL Server 2005 will install with SQL Server logins turned off. Again, on the SQL Server machine, open SQL Server Management Studio, right click on the server name in Object Browser, go to the properties section, and enable SQL Server logins. This will require a service restart to take effect. Create a login, and you should be able to use it from the laptop machine. |
 |
|
|
R
Constraint Violating Yak Guru
328 Posts |
Posted - 2008-12-04 : 08:51:09
|
| Hi mcrowleyThanks for your input. I'll give that a try. |
|
|
|
|
|
|
Connecting 2 pc's to copy a database - error