Rename SQL Server 2000 network name
Thu, 11 Sep 2008 13:09:01 -0700
I need to rename the host box for a SQL Server 2000 installation (no named
instances).
Can I just stop SQL Server, change the network name, reboot the box and have
the default instance of SQL Server come up and be accessable without any
other action?
Are there any gotcha's for me to be concerned with?
...
|
Visual Studion 2008 SP1 can not connect to sql 2008
Wed, 10 Sep 2008 07:28:01 -0700
have a fresh new install of VS2008 on Vista 64Bit and SQL management studio.
I manage to connect to the sql 2008 from within the management studio but
when I am not able to create a database connection from within VS 2008.
When I launch the wizard in VS, click the "server name" droplist, I can see
the name ...
|
Remote Connection to SQL Server 2008
Tue, 9 Sep 2008 23:57:01 -0700
Remote connections seem to be quite a complex issue judging from the
voluminous discussions on it. I have been trying to get an ODBC connection
to a remote SQL Server 2008 without success. I have examined the error logs,
used sqlcmd -L, used pipes, including stepwise implementation of
recommendations. All ...
|
Error Executing Database Query Connection reset errors.
Tue, 9 Sep 2008 16:03:54 -0700 (PDT)
Recently we migrated our database server to a separate machine.
This machine was on a separate standalone IP (our hosting company
could not allow the two machines to be networked together), which
we can connect via CF datasource.
The website works fine and is actually faster than before when
everything w ...
|
how do i detect the curret DB?
Sun, 7 Sep 2008 19:04:18 -0400
i need to change the options on the current DB. the first thing i need to do
is alter database "xx". How do i detect the current database name
programatically with a TSQL-script?
Leon
...
|
local connection to SQL2005 Enterprise on a Windows Server 2008?
Sat, 6 Sep 2008 13:46:04 -0700
Hi there,
I'm trying to connect locally to my SQL Server 2005 Enterprise from OS
Windows Server 2008, but it doesnt work. Ive searched on the internet what
the problem could be and i found out that i needed to set some settings in
SQL Server 2005 Surface Area Configuration. But when i clicked on the link
...
|
Linked Server: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON
Wed, 3 Sep 2008 08:55:02 -0700
I'm trying to setup a linked server. The issue I am having is this error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server,
Error: 18456)"
Server A is SQL 2005 windows logins only Server B is the same (SQL 2005
windows logins only)
Server A runs windows XP Server B runs Windo ...
|
|
|
IIS Windows Authentication Issue. Please Help.
Tue, 2 Sep 2008 12:14:02 -0700
We have asp.net application setup using Windows Authentication. For the
website, under directory security the only thing checked is "Windows
Authentication". We have the users specified in SQL who have rights to
connect...etc. In the Web.Config, it is specified as Integrated
Security=true. However, when the ...
|
OLE DB SQLNCLI "expected data length" error
Tue, 2 Sep 2008 11:21:01 -0700
Msg 7347, Level 16, State 1, Procedure proc_UpdateMetadata, Line 122
OLE DB provider 'SQLNCLI' for linked server '<server>' returned data that
does not match expected data length for column
'[server].[database].[dbo].[ObjectDescription].ObjectNumber'. The (maximum)
expected data length is 24, while the retu ...
|
mirroring database user account problem
Tue, 2 Sep 2008 23:46:20 +0800
I setup a mirroring database, have principal (host A), mirroring (host B),
withness (host C)
i create a user account and login account "usera" can login can retieve data
in principal server (host A)
when occur failover to host B, host B become principal, but i can connect
host B using "usera", i saw host B ...
|
