Sql server does not exist or access denied

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Sql server does not exist or access denied

Author

Topic

gpatrick
Starting Member

2 Posts

Posted - 2009-08-26 : 15:29:10

Server Operating System: Windows server 2000
MS SQL Version: MS SQL Server 2000
Client Machine Op. System: win xp sp3

sql server is currently installed on our server using the default instance. we are using a third party software namely Real-Time Analytical Intelligence Database (RAID) to create/install our database on sql server. all client machines can connect to the RAID database which is located on the sql server via the RAID application installed on the client machine.

However, when an attempt is made to create a new database on sql, via the RAID Application on the client machine, the following error is returned:

"Sql server does not exist or access denied"

I have since installed the RAID Application on the server where sql server is installed and tried creating a new database and i'm successfull. I did this mainly to determine whether it was possible to create a new database on sql with the RAID App. I have tried the "telnet <servername> <portnumber> command and i am able to telnet to the server. THe name of my server where sql is installed is "SERVER" Sql was installed to a default instance.

Like i said, i can connect to the RAID database on sql from a client machine but cannot create any new databases.

HElp please!!!

gpatrick
Starting Member

2 Posts

Posted - 2009-08-28 : 13:44:51

Here are some of the Event Logs i am receiving. Any help would be appreciated.

No.1

Event Type: Warning
Event Source: RAID-3
Event Category: None
Event ID: 100
Date: 8/28/2009
Time: 12:13:28
User: N/A
Computer: ADMIN
Description:
Timestamp: 8/28/2009 12:13:28 PM
Message: HandlingInstanceID: 773e9dff-d432-4b1d-80a3-e0e78d2f1aa2
An exception of type 'NDIC.RAID.Common.GeneralSQLException' occurred and was caught.
------------------------------------------------------------------------------------
08/28/2009 12:13:28
Type : NDIC.RAID.Common.GeneralSQLException, RAID.Common, Version=3.2.1.213, Culture=neutral, PublicKeyToken=be3fbf7ff2e1b6f7
Message : There is a problem with the database and the operation was not completed. Please check with the administrator.
Source :
Help link :
TargetSite :
Stack Trace : The stack trace is unavailable.
Additional Info:

MachineName : ADMIN
TimeStamp : 8/28/2009 4:13:28 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=1.0.0.6, Culture=neutral, PublicKeyToken=729d7be5c4aa9ce3
AppDomainName : Raid.exe
ThreadIdentity :
WindowsIdentity : FIU\Administrator
Inner Exception
---------------
Type : System.Data.SqlClient.SqlException, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : SQL Server does not exist or access denied.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 20
LineNumber : 0
Number : 17
Procedure : ConnectionOpen (Connect()).
Server :
State : 0
TargetSite : System.Data.SqlClient.SqlInternalConnection GetConnection(Boolean ByRef)
Stack Trace : at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DBCommandWrapper command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(CommandType commandType, String commandText)
at NDIC.RAID.DataAccess.DatabaseHelper.DoesLocalDBExist(String dbName)

Category: EventLog
Priority: 0
EventId: 100
Severity: Warning
Title:Enterprise Library Exception Handling
Machine: ADMIN
Application Domain: Raid.exe
Process Id: 4732
Process Name: C:\Program Files\NDIC\RAID\Raid.exe
Win32 Thread Id: 5400
Thread Name:
Extended Properties:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

No.2

Event Type: Warning
Event Source: Enterprise Library Data Service
Event Category: None
Event ID: 10
Date: 8/28/2009
Time: 12:13:31
User: N/A
Computer: ADMIN
Description:
Data connection failed to open: integrated security=true;server=.;

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Thanks again for you'll anticipated assistance in this matter.

Patrick

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources