Web Wiz Support and Community Forums : Urgent help Connecting to Database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:24:13 +0000 Fri, 09 Jun 2006 08:53:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20225 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Urgent help Connecting to Database : I&#039;m not an expert on SQL...]]> https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108724.html#108724 Author: WebWiz-Bruce
Subject: 20225
Posted: 09 June 2006 at 8:53am

I'm not an expert on SQL Server permissions, but this sounds to me like a permissions error connecting to the database.

It's been a while since I got an error like you mention, but I think the last time I did was because the SQL server was not set to allow remote sa connections.

Try having a look on some SQL Server web sites for more help as they can probaly give you better advice when connecting to a SQL server and the correct permissions.
]]> Fri, 09 Jun 2006 08:53:00 +0000 https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108724.html#108724 <![CDATA[Urgent help Connecting to Database : I have no choice at present but...]]> https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108676.html#108676 Author: lynnami
Subject: 20225
Posted: 08 June 2006 at 3:30pm

I have no choice at present but to move to SQL 2000 - this is a done deal.  I have two instance of SQL 2000 server running.  The default SQL server on <ServerName> was previously accessed as follows:
 
Driver={SQL Server};Server=<ip Address>;UID=<SQLUser>;PWD=<SQLPassword>;Database=<DatabaseName>;
 
one instance of SQL reverts to the default server name <ServerName> and the other <ServerName>/SecondInstance.
 
The SQL server settings are Mixed mode but when I try and use sa password I get 'not a trusted SQL connection' errors.
 
Please assist with connection string I should use in both instances.  Or must I change settings on server and then add users to NT  authorities?
 
 
Many thanks


Edited by lynnami - 08 June 2006 at 3:31pm]]> Thu, 08 Jun 2006 15:30:35 +0000 https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108676.html#108676 <![CDATA[Urgent help Connecting to Database : If you are upgrading from version...]]> https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108668.html#108668 Author: WebWiz-Bruce
Subject: 20225
Posted: 08 June 2006 at 1:01pm

If you are upgrading from version 7 you should bypass 2000 as that is also dated now and go for SQL Server 2005

You need to make sure you are running the SQL server in mixed mode and allowing TCP/IP connections.

Also, include the instance name when connecting to your database..
]]> Thu, 08 Jun 2006 13:01:38 +0000 https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108668.html#108668 <![CDATA[Urgent help Connecting to Database : Hi all I have had to re-install...]]> https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108664.html#108664 Author: lynnami
Subject: 20225
Posted: 08 June 2006 at 11:38am

Hi all

I have had to re-install my SQL server (7) - I used the opportunityto upgrade to SQL 20000.  I am now having problems connecting to theDB.  This is a remote server and I connect via the internet (remotedesktop for admin)

Previously I used the IP address eg 192.41.6.200  (Named COSMOS) for theSQL server with no issues.  Now I have Two instances of SQL Server runningon the same Machine.  one is the default named 'COSMOS'  and theother is 'COSMOS\MAC'

I had no problems before using the ip address but now I cannot connect usingvariations of the above.



Can anyone help me?

Lynne
]]> Thu, 08 Jun 2006 11:38:19 +0000 https://forums.webwiz.net/urgent-help-connecting-to-database_topic20225_post108664.html#108664