I have purchased a dedicated server from GoDaddy.

Ive installed MS-SQL Express 2005 to be used for an internal application.

Windows 2003

Firewall Turned Off (just until i figure this problem out)

I cannot connect to the database from remote. Ive tried everything ive read
about (turning on remote connections, etc) and am still having no luck.

GoDaddy wont help because i didnt purchase their managed services.

Is there something else im missing? Is this a setup issue, or something
particular with a GoDaddy dedicated server?

TIA

Tim

I thought so. But this is the first time ive tried.

Could that be my problem?

Im sure there is someone here that might have that answer.

I do it all the time on a LAN of course, but this is my first time trying to
do it from a remote dedicated server like this.

Tim

"Brett I. Holcomb" bellsouth.net> wrote in message
news:jbb5t3t1o4mdehb99vp9pj4m8d0q3hmjas@4ax.com...

Hi Tim,

What's the error message you get? You better investigate the problem from
SQL Error Logs if it's only about SQL Server connection. Can you reach to
the Windows Server for example? Or is your problem only with SQL Server
remote connection?

If your SQL Server Instance is a Named Instance then ensure the Browser
Service is running. Or if it's a static port then ensure you are using the
right port # to connect.

--
Ekrem Önsoy

"Tim Morrison" NOSPAMkjmsoftware.com> wrote in message
news:uY15METgIHA.5900@TK2MSFTNGP02.phx.gbl...

It is just with the SQL Server. I can reach the server with RDP, and VNC,
and some custom apps i have running. just not SQL.

Tim

"Ekrem

I think you have an application, so can you show your Connection String?

Is your SQL Server Instance a Named Instance or a Default Instance? I also
asked you to check out the SQL Error Logs, but you did not provide any info
about it yet. It's going to be the error message which will help us to solve
the problem. For example with the help of the error message we can
understand if the error is about a Login\Access problem or a connection
problem or something else...

--
Ekrem Önsoy

"Tim Morrison" NOSPAMkjmsoftware.com> wrote in message
news:O$lxeaWgIHA.1212@TK2MSFTNGP05.phx.gbl...

This is the message if i do not specify a port:

TITLE: Connect to Server
------------------------------

Cannot connect to ***.***.**.**\KSOFT. [IP ADDRESS HIDDEN]

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID...

------------------------------
BUTTONS:

OK
------------------------------

This is the message if i do specift a port:

Can you ping the server?
Please try to create an alias at the client machine and try to connect it.

--
RABINDRA DAS
"Tim Morrison" NOSPAMkjmsoftware.com> wrote in message
news:uerAI0egIHA.4536@TK2MSFTNGP06.phx.gbl...

I have a problem like this. The question I have is, can you use SQL server
Express on a workgroup network and log into the SQL from a different system?
In otherwords, the network does not have a windows server anywhere so there
is no primary or secondary domain controller or active directory.
--
AutoCAD programmer

"RABINDRA DAS" wrote:

AutoCAD_dll_junky wrote:

Yes you can.
I have SQL Server 2005 Express edition on a windows workstation and a
JEE application on a Unix workstation which uses the SQL Server as one
of its databases. It is accessed using the JDBC driver and TCP/IP protocol.

OK-
I've set the following and I get a permissions error

1) SQL server Express is configured for allowing remotes both named pipes
and TCP/IP.
2) SQL browser is enabled and set to autostart.
3) SQL server express is running on Vista home.
4) SQL server is configured for mixed mode authenication
5) Client is running on XP64.
6) firewall allows server and browser through.
6) all logins are in the admin groups.
7) the client can browse the network and find the instance of SQL express.

I get the message when trying to connect:
Cannot connect to \SQLEXPRESS
Login failed for user \Guest
(I have logged in as Admin not Guest)

I also just found this article saying you need to use SQL server
authenication not windows. Two work arounds are not recommended.

http://blogs.msdn.com/sql_protocols/archive/2007/05/12/connecting-to-sql-server-from...