Connection Failed - Microsoft SQL Server

Mike Pavel via SQLMonster.com

I have added a domain global group to the local administrators group on server running sql 2000 with sp3a. The os on the server is w2k with sp4. The builtin\adminis trators group has sa rights. Yet members of the domain global group, after they logon to the server through a remote desktop session cannot open sql enterprise manager & connect to the local sql server (default instance). They get a message "Cannot open user default database. Login failed.." The users of the domain global group can connect to 2 other instances of of sql on the same server. The default instance is 8.00.818. The other 2 instances are 8.00.760. Thanks in advance for any advice.

*************** *************** ***********
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....b2402cee65437e
*************** *************** ***********

Jul 20 '05 #1

Subscribe Reply

4077

Erland Sommarskog

Mike Pavel via SQLMonster.com (fo***@SQLMonst er.com) writes:

I have added a domain global group to the local administrators group on
server running sql 2000 with sp3a. The os on the server is w2k with sp4.
The builtin\adminis trators group has sa rights. Yet members of the
domain global group, after they logon to the server through a remote
desktop session cannot open sql enterprise manager & connect to the
local sql server (default instance). They get a message "Cannot open
user default database. Login failed.." The users of the domain global
group can connect to 2 other instances of of sql on the same server. The
default instance is 8.00.818. The other 2 instances are 8.00.760. Thanks
in advance for any advice.

Each login on an SQL Server has a default database. Now, if for some
reason they cannot access that database, login fails. This can be
because they don't have permission to the database or that database is
offline of non-existing.

You can use the stored procedure sp_defaultdb to change the default db
for a user. Please see Books Online for syntax.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #2

Mike Pavel via SQLMonster.com

The domain global group is part of the nt local admins group on the server running sql which makes it part of the built\administr ators group in sql which has dbo access to all the databases on the sql server. The default database does exist. Thanks for reponding to my question. Any more thoughts?

*************** *************** ***********
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum....ql-server/5079
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....fff59ba325a2b2
*************** *************** ***********

Jul 20 '05 #3

Erland Sommarskog

Mike Pavel via SQLMonster.com (fo***@SQLMonst er.com) writes:

The domain global group is part of the nt local admins group on the
server running sql which makes it part of the built\administr ators group
in sql which has dbo access to all the databases on the sql server. The
default database does exist. Thanks for reponding to my question. Any
more thoughts?

Well, the error message you get, usually means that the default database
is not accessible. This can be because of several reasons:

o The database does not exist.
o The user does not have permission to the database.
o The database is offline or in single-user mode.

Can they log in through Query Analyzer or OSQL? In such case, change the
registration properties in Enterprise Manager.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #4

Similar topics

2012

server bootstrapping upon connection (WARNING: LONG)

by: Fortepianissimo | last post by:

Here is the situation: I want my server started up upon connection. When the first connection comes in, the server is not running. The client realizes the fact, and then starts up the server and tries to connect again. This of course all happens on the same machine (local connection only). The connections can come in as fast as 30+/sec, so...

Python

31092

by: Blake Versiga | last post by:

I am pulling my hair out..... I am trying to put a bound data grid on a webform... I have 4 data connections in my server explorer, all of which connect successfully. But when I run the web page I get the error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I use a connection string in my...

ASP.NET

2153

Trusted SQL Server connection

by: Ray Valenti | last post by:

I am able to preview this data in the development environment, but when I run the application the error below shows up. How do I set up a Trusted Connection? -Ray Server Error in '/WebApplication2' Application. ---------------------------------------------------------------------------- ----

ASP.NET

3090

website connection to database time out problem : login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

by: Maellic | last post by:

Hi, The website I am working on is built with ASP.NET and connects to a SQL Server 2000 database. The web server and database are on the same machine. I have recently tried to modify the timeout of the website from 20 mn to 60 mn. I changed the timeout setting in IIS. Now the website itself doesn't time out, however after 20 mn, when I try...

ASP.NET

2446

Connection Pool

by: Jim Heavey | last post by:

How do I set up a Connection Pool? How can I look on the server and see how many connections are being used by my application? I am pretty sure that my application must be leaving connections open, because I begin to receive error message indicating that the system can not open a connection and I should check my connection pool, with me...

ASP.NET

1233

python xmlrpc: cannot handle connection errors

by: xristoph | last post by:

Hello everyone! I am trying to set up a broker-worker system (one broker, multiple and heterogeneous workers) in python for a local network (though possibly also over inet). I am using SimpleXMLRPCServer and xmlrpclib.ServerProxy for connections. Whatever I do, after about 100,000 to 150,000 XMLRPCalls over a single ServerProxy...

Python

9745

A connection attempt failed problem

by: Dennis | last post by:

I'm getting the following problem occasionally...the application will work perfectly well for a period of time and then this pops up. I have tried turning off the default proxy in the web.config which I had seen on other posts but that did not solve the problem. Any assistance or ideas would be appreciated Thanks

ASP.NET

2620

C# - SQL Server Express Connection Problem

by: dc | last post by:

I have a baffling connection problem from my C# console app to a sql server express database. The console application opens the sql database using the following code:- vDataSource = "server = " + vgSqlServer + "; " + "database = " + vgSqlServerDb + ";" + "uid = XXX; pwd = XXX; ";

C# / C Sharp

12069

by: eruth | last post by:

There are loads of post on this, but nothing that seems to cover my exact problem ;) I have an ASP.Net 1.1 web application running on my local machine. I want to connect to an SQL 2005 server running on Windows 2003. If I use SQL authentication, all is fine and dandy. If I want to use windows authentication it gives the above error. My...

ASP.NET

7912

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

8202

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8338

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

6614

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5390

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3865

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2345

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1449

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1180

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General