Re: Remote Connection to SQL 2005

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" <sales@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:O$lxeaWgIHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
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 Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message news:E9F04F90-2C4E-4E96-8760-08329A9DE76C@xxxxxxxxxxxxxxxx
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" <sales@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:uY15METgIHA.5900@xxxxxxxxxxxxxxxxxxxxxxx
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" <brettholcomb@xxxxxxxxxxxxx> wrote in message news:jbb5t3t1o4mdehb99vp9pj4m8d0q3hmjas@xxxxxxxxxx
Does Express allow connections to remote databases? Some of the
express products do not.

On Sat, 8 Mar 2008 09:03:37 -0600, "Tim Morrison"
<sales@xxxxxxxxxxxxxxxxxxxxx> wrote:

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







.

Relevant Pages

  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
    ... I tried adding the TCP but then I get a error message "Microsoft Office Accounting cannot open the company because of a connection error." ... I assume that's why trying to force a TCP connection doesn't work. ... Rick Byham, SQL Server Books Online ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
    (microsoft.public.sqlserver.connect)
  • RE: Error 17835 - When encryption and Shared Memory are enabled
    ... Did you encounter this error when you connected to your SQL Server ... Did your SQL Server instance use a certificate explicitly specified by ... you configure your client connection settings "Force Protocol Encryption" ...
    (microsoft.public.sqlserver.connect)
  • Re: Trusted connection to SQL Server 2000
    ... As the error message says, the user ASPNET could not logon. ... I do not have either SQL Server or the ... > Roslyn L. ... >> If you can use a trusted connection to connect to SQL Server ...
    (microsoft.public.sqlserver.security)
  • RE: MS03-031: Cumulative Security Patch for SQL Server
    ... Microsoft SQL Server 2000 by using named pipes, ... Connection could not be established. ... To obtain a hotfix to resolve this error message, ... SQL Server Developer Support Engineer, MCDBA, MCSE, MCT ...
    (microsoft.public.sqlserver.security)