Re: Connecting to remote SQL Server

From: Bob Simms (bob_simms_at_somewhere.com)
Date: 11/06/04 

Date: Sat, 6 Nov 2004 22:04:54 -0000

"Bryce Fischer" <spamtrap@berzerker-soft.com> wrote in message
news:3btpo01us397pf1gmfl4bt9c8k9dcrv05e@4ax.com...
> I have SQL Server 2000 (Developer) on my computer. So I have SQL
> Server Enterprise Manager + Tools (such as Query Analyzer).
>
> I am doing some work on a remote server, mostly ASP pages (not
> ASP.NET). There is a SQL Server database on that server. I would like
> to use Enterprise Manager or Query Analyzer to access that database.
>
> My main development environment is Dreamweaver MX2004. In Dreamweaver,
> I was able to setup the database (on the databases tab) using a
> "Custom Connection String", listed below (some info obfuscated for
> security):
>
> "Provider=SQLOLEDB.1;Persist Security Info=False;Initial
> Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
> Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
> Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
>
> I don't know if it is possible to use the other tools to manage this
> database. I've tried the following:
>
> 1. In Enterprise Manager, I've tried just putting the ip address as
> the server, and "Use SQL Server authentication" from the user ID and
> Password above, but I get the following error:
> "SQL Server registration failed because of the connection failure
> below... Cannot open user default database. Login failed"
>
User XXX has a login on the remote server, but does not have a user in the
database he is configured to use. To administer the remote database, User
XXX must be a member of the sysadmin role on the remote server 

---
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004

Relevant Pages

  • SQL CE Setup 101... C#
    ... "The remote server does not exist or has not been designated as a valid ... along with "Initializing SQL Server Reconciler has failed. ... // Create the Local SSCE Database subscription. ... IncontrolNew is the database the ip address is the ip addy to the ...
    (microsoft.public.sqlserver.ce)
  • Re: Backing up SQL Server problem
    ... Are you trying to move local logins to the remote server? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > 'myusernameforsqlserver' does exist on the remote server - what I can't ... > to log on to the remote database and to create my tables and SPs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Updating remote MySQL databases
    ... than over Internet directly to the database. ... > I want to maintain with the WinForms program. ... > remote server, that would probably be done with PHP or whatever. ... > the appropriate dialect down the TCP/IP connection from my local PC to ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: enterprise manager no longer connects to remote database
    ... Get onto the remote server and for the login, change the default database. ... Mike Epprecht, Microsoft SQL Server MVP ... Fasthosts technical support advise me to reload SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to remote SQL Server
    ... >User XXX has a login on the remote server, but does not have a user in the ... To administer the remote database, ... As I mentioned, in Dreamweaver, I'm ...
    (microsoft.public.sqlserver.server)