|
Cannot open user default database. Login failed when login with group id
Hello
I got the following error when logon the SQL Sever.
"Cannot open user default database. Login failed"
so, I changed default database with my user id using sp_defaultdb. And then I could login the SQL sever.
I changed default database with window domain group id using sp_defaultdb, but the user ...
Fri, 14 Jan 2005 19:50:41 GMT
|
Error 7391 when inserting remote sp call results
We replaced our Windows Server 2000 data warehouse (DW) server with a Server
2003 machine. The DW db is in SQL 2000, SP3 (8.00.760). The DW is
populated using remote queries and remote sp calls to the production server.
The latter server is running SQL 7.00.1094.
The DW code can do remote selects, and ...
Thu, 13 Jan 2005 12:53:06 -0800
|
SuperSocket Info: Bind failed on TCP port 1433
Receive this error when starting SQL: SuperSocket Info: Bind Failed on TCP
port 1433
SQL Error Log:
2005-01-12 16:01:35.78 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-01-12 16:01:35.81 server SuperSocket Info: Bind failed on TCP port
1433.
2005-01-12 16:01:35.82 server SQL server liste ...
Wed, 12 Jan 2005 16:17:18 -0600
|
problem about register a remote sql server
hello
my pc is in LAN , os: win2000 server sp4 ,sql server:sql server2000 sp3
remote pc : win2000 server sp4 ,sql server 2000 sp3
I can connect to remote sql server using osql. when I register the remote
sql server by enterprise manager .the error occur :
connectionread{recv{}} general network error
...
Wed, 12 Jan 2005 11:04:49 +0800
|
Server query processed at local and not remote SQL Server
Hi, I have a client who is conneting to my server from theirs via a linked
server they've set up.
They perform the following query:
DECLARE @abcid int
SET @abcid = 123
SELECT abc_id
FROM [Server1\NamedInstance1].DB01.dbo.View01
WHERE (abc_id = @abcid)
The execution plan in Qu. Analyser returns h ...
Tue, 11 Jan 2005 18:47:03 -0800
|
Sql Command Timeout
Hello,
I've got a SQL query that times out on my SQL 2000 DB. I used query analyzer
and it works great it took 57seconds to complete. I run it in VB6 and it
times out. I set the connection timeout to 0 but to no avail it craps out at
30 Seconds. Is there a command timeout? Would this solve my problem. I'm ...
Tue, 11 Jan 2005 10:53:01 -0800
|
Software for connecting to a remote SQL Server
Hi All,
I would like to be able to connect to a remote SQL Server and fire arbitrary
queries, browse tables, and so forth. Very much like MS's "SQL Server Web
Data Administrator" (link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en).
However ...
Tue, 11 Jan 2005 18:45:52 GMT
|
ASP .Net connection to Sql Server
Hi,
I have a new ASP .Net project that has been developed on our
development machine and connects to SQL Server 2000 on the same
machine. It is connecting via a connection string similiar to:
Data Source=[Machine Name];Initial Catalog=[Our
Catalog];uid=[Username];Password=[Password]
Everything works fi ...
11 Jan 2005 09:29:01 -0800
|
Connection limits to database by operating system
Can someone point me to documentation related to the number of connections a
database can have before there is a degradation in the connection?
I was told that if you have a database on a computer with a Windows 2000
operating system you can only have 5 connections to the database or the
connections will b ...
Tue, 11 Jan 2005 06:33:07 -0800
|
Login failed for user '\'.
I have an asp program that calls a C program that uses db-library to connect
to Sql Server 2000. The error produced is "Login failed for user '\'." Here
are some of the particulars
Web Server is running Windows Server 2003
Database server is running SQL Server 2000 on Windows NT 4
The program r ...
Mon, 10 Jan 2005 11:41:02 -0800
|
Distributed Query Connection Issues
I have the following situation: I have a database on ServerA and a database
on ServerB. My client app connects to ServerA and uses a stored procedure to
retrieve a dataset from both ServerA and ServerB.
While developing the app (using SQL 2K Dev on my workstation), I used a
linked server approach. I linke ...
Mon, 10 Jan 2005 10:55:01 -0800
|
XP / SQL personal: Cannot find localhost
Hi,
I installed SQL Server 2000 personal edition on my Win XP sp2. In the
enterprise manager, I can manage my local database, but if I try to connect
via the Query analyzer, it says it cannot find the server or the access is
denied.
I added localhost in the Client network utilities and it still doesn't ...
Mon, 10 Jan 2005 08:59:01 -0800
|
Change default port no.
Hi,
As we know,SQL server listens on port 1433 by default. Is there any
dependency between client and SQL server for this port number?I mean, how
will know the client that on which port the target SQL server listens?
Suppose I change this port number to 1533 and restarted the SQL server.Now I
tries to c ...
Mon, 10 Jan 2005 01:21:02 -0800
|
how to SQL Server register?
my SQL Server version is 2000
How to register New Sql Server with local machine?
and how to connect?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! ...
Sun, 09 Jan 2005 23:09:02 -0800
|
change a named instance to default instance
Hello Brian,
Appreciate your update and response. I am glad to hear that the problem has
been resolved. Based on my test, the alias which is configured by using
TCP/IP Sockets or Named Pipes works.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasu ...
Mon, 10 Jan 2005 04:48:24 GMT
|