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 |
|
garybelvin
Starting Member
2 Posts |
 Posted - 2008-05-02 : 09:52:36
|
| Hey guys, I am new to the SQL server scene and I am having some trouble connecting to a remote SQL Server with SQL Server Management Studio Express. I have the username, password, IP address, and port necessary to log in but am apparently not plugging them into the correct places. Can anyone at all point me in the right direction or somewhere that I might at least find the answer? I appreciate any help that can be provided.Thanks a bunch,Gary |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-02 : 22:03:56
|
| Do you have permission for SS? |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-05-03 : 01:36:39
|
| Do you get an error? Where are you "plugging them in?"Nathan Skerl |
|
|
|
garybelvin
Starting Member
2 Posts |
Posted - 2008-05-03 : 19:12:18
|
| I had installed SQL Server 2005 on my machine before with the intentions of trying to learn it. I can't remember setting up anything with it, but by default it has a server in the SQL Server 2005 Services with my computers name. I am putting an alias name, port number, TCP/IP protocol, and the server IP address in the aliases section. Then on New Server Registration in SSMSE I put in the server name as the alias I have set up, SQL Server Authentication, I enter the User ID and Password and click test connection but to no avail. I apologize if this is not specific enough as I'm not entirely sure what to be specific about nor am I hip with the lengo quite yet, but I am trying. Thanks a bunch of the responses guys.Gary |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 20:38:17
|
| Did you get any error? Can you ping sql server from your machine? |
|
|
|
|
|
|
|
|
Help connecting to remote server with SSMSE