0
votes
1answer
1k views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
0
votes
0answers
20 views

BCM database accessable for all but ONE computer in domain

I have a small network of 6 computers running the latest version of good old WinXP and a Ubuntu Linux machine acting as PDC for the domain. All machines have MS Office 2010 Professional installed. ...
1
vote
1answer
486 views

SQL Server ODBC Connection via Command Line

I need to create a number of ODBC connections to a MS SQL Server, the clients are mainly XP machines. The connection has to use SQL server authentication - is there a way to do this remotely via ...
1
vote
1answer
126 views

How do I configure a stored procedure wrapper and security settings to provide safe access to command-line operations?

I'm ultimately trying to find a way to allow the safe use of BCP and selected other command-line functionality from within SQL Server. The organisation I am in currently have xp_cmdshell disabled ...
0
votes
1answer
253 views

SQL Server 2008 installation fail by performance counter issue?

I am installing SQL Server 2008 on Windows XP. In the first step to check system configuration, I met with a strange error like this, performance counter registry configuration item consistency ...
1
vote
2answers
2k views

SQLExpress service unable to start Error code 17053

A user was instructed by their software support to upgrade a program and install SQLExpress as part of the installation process. Since that time, the service has been able to start, citing error ...
2
votes
2answers
4k views

How to configure Windows user accounts for ODBC network with NT authentication?

I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running ...
1
vote
3answers
3k views

SQL Server access is slow on client machines

I was out on a clients site today and installed some custom software that accesses a SQL server 2005 database that resides on a server on the clients site. The software runs fine when ran directly ...
1
vote
2answers
119 views

Compatibility of SQL Server 2005 / 2008 and Windows XP UK Edition

Today I was told that the version of Windows XP for the UK is not the same as the one used in the US. Is this true? And if so, is there somewhere where I can learn the differences? Are SQL Server ...
1
vote
0answers
89 views

Problem with MSDE 2000 5 minute keepalive over ISDN

We have a SQL Server transactionally pushing replicate data to an MSDE 2000 SP3a subscriber over ISDN. Prior to a recent upgrade to bring us to the MSDE 2000 level we pushed to MSDE 1. We are finding ...
1
vote
2answers
205 views

Developer Laptop with SQL Server 2008 can't login to SSIS when offsite

When I bring my Windows XP (SP3) laptop home I can still login as my domain account because Windows caches the info necessary to authenticate me when the domain controller isn't around. However, when ...
0
votes
3answers
2k views

DSN, ODBC: How to create DSN using different windows account

Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create ...
2
votes
2answers
3k views

SQL Server Management Studio missing when I installed SQL Server 2005

For some reason SQL Server Management Studio is missing when I installed SQL Server 2005 Developers Edition. Any reason why or how can i get SQL Server Management Studio on my PC? My operating system ...
3
votes
1answer
2k views

Does Windows XP connection limit apply to Sql Server connections?

I have installed Sql Server 2005 on Windows XP acting as server in a small workgroup. Since XP has as limit of 10 computers connecting at the same time, my question is, does this limit also apply to ...
0
votes
2answers
643 views

How to install SQL Server 2005 evaluation on Windows XP?

I am frustated because when I try to install the evaluation edition of SQL Server 2005 it shows only the books online check box. I have installed Visual Studio 2003 first and the .NET framework 2.0 ...