Browse by Tags

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

Published 12 June 8 10:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New SQL Server 2005 installers...

Filed under: sql server, instance, kba, installation, 2000, 2005, msde

How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008

Published 24 December 7 4:38 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL...

Filed under: sql server, microsoft, instance, kba, 2008, pack, 2005, ifilter, register

Rename a SQL Server instance, a little catch

Published 14 December 7 4:4 AM | SSQA.net

Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by...

Filed under: sql server, msdn, technet, instance, read, best practices, installation, servers, rename, local

How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port

Published 18 October 7 3:31 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to configure an instance of SQL Server...

Filed under: sql server, instance, kba, tcp/ip, port, dynamicport

FIX: Error message when you use the SQL Server Native Client OLE DB provider to connect to an instance of SQL Server 2005: "Conversions not allowed using bcp_moretext"

Published 16 October 7 3:26 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you use the SQL...

Filed under: sql server, instance, kba, oledb, bcp, moretext, native client, errorr message

FIX: You cannot connect to an instance of SQL Server 2005, and an error message is logged in the SQL Server error log

Published 12 October 7 11:10 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, instance, kba, error log, 2005

Rename a SQL Server instance, is it possible?

Published 2 October 7 4:11 AM | SSQA.net

Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name...

Filed under: sql server, msdn, microsoft, instance, kba, installation, FAQ, developement, rename

FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"

Published 21 September 7 9:53 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, instance, kba, connections, database mirroring, principal, native

Shall I drop pubs and northwinds databases, how about Adventureworks?

Published 21 June 7 3:36 AM | SSQA.net

As you may be aware SQL Server installation (70 & 2000) will automatically install the sample databases pubs and northwind, if you aren't using them or not a training institute then simply drop them. Whereas this behaviour is changed in SQL Server...

Filed under: sql server, databases, microsoft, instance, documentation, sample, install

Alert when a specific SQL instance service has been started

Published 11 June 7 4:55 AM | SSQA.net

One of the IT support team member asked me the question " Is there a way to have SQL Server 2005 send some sort of email notification when it starts up? " The solution is straight forward and yes you can have such alerts or notifications based...

Filed under: sql server, instance, notification, alert, service

Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>'

Published 18 May 7 5:56 AM | SSQA.net

You might have come across this instance of error within your environment: Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' The above error used to drive me nuts when the users complained by...

Filed under: sql server, update, users, instance, localhost, error, login