| Author |
Topic |
|
StealthRider
Starting Member
13 Posts |
 Posted - 2009-05-14 : 17:58:52
|
| Hello, I'm new here and looking for some help with SQL 2005. I have installed SQL and now what I would like to do it connect to the resever remotely.Since cox blocks port 1433 I have configure the SQL server to listen on PORT 1444. I need help configuring the client to use port 1444 to esatblish connection.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
StealthRider
Starting Member
13 Posts |
Posted - 2009-05-14 : 18:50:10
|
Yes, I have tried that. I had to configure the SQL server to listen on port due to Cox blocking port 1433. The port that the SQL server is listening on is 1444.For some reason when i try to connect with IP ADDRESS:1444 Can't connect, get error message: Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
StealthRider
Starting Member
13 Posts |
Posted - 2009-05-15 : 17:32:30
|
Thanks, Now I'm using commas and i get the following errors:Windows Authentication SQL Server Authentication  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-05-15 : 17:50:09
|
| That means you can connect to SQL Server, but the account you are trying to use does not have access. So you need to try with an account that has access. You can't use Windows authentication unless the current security context (the user you are logged into on the client) matches with a valid account on the database server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
StealthRider
Starting Member
13 Posts |
Posted - 2009-05-15 : 18:03:19
|
| Well I guess my new question, is how to configure this so that I can log in using SQL Server Authentication.I don't remember setting up a user name and passwordThanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL Remote connection Help