Howdy! I'm writing a little script that should run at bootime. The script should connect to SQL Express and retrieve some values from a view. Running and testing this script as administrator works without problems. Running this script at boottime results in a refused connection to sq...more >>

I'm currently trying to understand SQL Server Windows Authentication ahead of writing an application that needs to connect to SQL server. The server is a machine named 'databaseserver' that runs SQL Server Express 2005 in Windows Authentication mode. The server is a Workgroup computer, not on ...more >>

Hi, I am using dot net 1.1 framework to connect to one of my data base. the connection string looks like following "Data Source=.\SQLEXPRESS;AttachDbFilename=c:\DB1.mdf;Integrated security=true;User Instance=True" when I run my program without debugging, the exception of "unsupported ke...more >>

I'm using SQL 2000 & MSDE 2000 I'm having a problem connecting to a local database running on MSDE but only when the computer isn't connected to the network. I've tried using both TCP and named pipes, both work while connected. This was not an issue until MS updates were installed. MSDE i...more >>

I have SQL/Server Express set up on two machines. I turned on all the protocols for each. I started the server browser task on each. I opened ports 1433 and 1434 on both firewalls. I can sometimes find the servers when I browse. I just can't logon from either. I've tried logging on as 'sa'...more >>

Hi, I am having a very frustrating problem trying to connect to a remote SQL Server 2005 at my ISP. When I try to connect through Management Studio the ISP SQL Server returns an error of 'Login failed for user xxx (18456)'. According to the ISP they can see my connection attempt in their lo...more >>

(CrossPost: microsoft.public.opsmgr.sql, = microsoft.public.sqlserver.connect, microsoft.public.sqlserver.server) I installed SQL Server 2005, then i reboot the server (w2k3 r2 std ed), = then i saw the following event: Actually i reformated my sql server because of this event, and now it's = ...more >>

My available memory is down to very little, yet my PF Usage is 8 gigabytes (about how much memory is on the box), sql server keeps having memory issues yet the sqlservr.exe is using hardly any memory.. how to fix this? is there some way to limit how much memory can be used by this PF Usage? wh...more >>

in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure? ...more >>

Create table myTable ( Name varchar, Description Text ) The description column contains more than 300 characters. The sql limit is to show only 30,35 words. Is there any tool available which can export around 5000 characters or more data of a single column. Regards ...more >>

hi, i have a simple question, mit look silly question for some one.. but please look into it n let me know how to write a query for it.. i have 3 cols col1 col2 col3 ----- ----- ------ 123 null 1159 434 null 1159 555 233 1490 999 null 1440 234 667 1159 the result set should...more >>

I am trying to create a linked server between 2 SQL Servers. The server that I'm trying to connect to has 2 instances of SQL Server on it. One is SQL 2000 STD and is the default instance. The other is SQL 2005 Wrkgrp and has the instance name 'sql05'. I need to be able to connect to the linked...more >>

Hi. I cannot connect to SQL Server 2005 Express on a Windows XP SP2 machine from a Windows 2000 PC using the SQLNCLI OLEDB provider in VB6. I can create an ODBC System DSN and connect just fine, but I cannot use a connection string with "Provider=SQLNCLI" or "Provider=SQLNCLI.1". I always g...more >>

Hi! I have downloaded Club Website Starter Kit from MS. I don't have SQL Server Express but I do have SQL Server 2005 Development. I have changed the name of the DB server in the connection string, but nothing else in the string. Remote connections is aloud and port is set to 1433. W...more >>

Background... Server raid failed, rebuilt raid ran chkdsk but now I am unable to run SQL service. I've tried to manually start service but receive the following message The MSSQLSERVER service on the local computer started and then stopped. Some services stop automatically if they have no ...more >>

SQL Server 2005 enterpise edition with 8g or memory in the compaq dl380 server with AWE enabled. I think the server is using about 7g. Connections are 0 - unlimited I have a .net application that tries to create 300 connections async and start a small process on each connection from one works...more >>

Hi I have installed SQL Express with advanced services and all the toys on 2 machines. A desktop and a laptop intending to use the desktop as a "server". I followed instructions to enable the server installation for remote connection by enabling TCP and the browser. Using SQL Server manager...more >>

Have asp.net applic connecting to remote SQL Server. Is it possible to specify to use SPs on different server? ( i.e. local rather than remote)...more >>

Hi: I have a SQL 2005 instance (standard edition with sp2 on windows 2003 server) located on different domain. I can connect to it by using sa only via SQL server management studio. I need to use SQL login. I created another user called 'test' and granted with sysadmin server role, bu...more >>

After months of frustration, not knowing what was causing the disruptions, I caught the culprit live, in its tracks. And that beast is Active Sync. I was running a long process, generating test data, and when I pulled my PDA out of the cradle, I heard the normal "ding", signifying that the devi...more >>

I've been using Delphi for years (Win 32) and connecting to my SQL Server databases with no problem. I am now trying to learn both VB and C#. (Visual studio 2005) From the Data menu, I select Add New Data Source I then choose Database I select Microsoft SQL Server as the Data Source The ...more >>

I am unable to login to Server Management Express using Server Authentication. I am able to login using Windows Authentication though. I setup a new logic using Server Authentication but get the following message: Cannot connect to MIKE-PC. =================================== A connection ...more >>

I have just installed Sql server 2005 on my Win XP Pro machine. When I go into the sql server management studio, there is only one entry under the "database engine" entry in the registered servers' panel on the left. It is MyServerName\SQLEXPRESS. When I click on it and then select connect, eit...more >>

We have an application that we run at our business that takes a long time to run on our old server. We purchased a new server and I have been told we are going to run SQL Server 2005 STD x64. When I ran the program as a test on our new server it took twice as long as the older slower server. ...more >>

I am looking for guidance. I do SQL and other development on 2 computers, and I work remotely from my company's home office. (We use SQL 2000 and 2005 both.) My "main" computer has a VPN to the home office. Outside of that, and before the VPN was set up, I had a TCP connection to ONE of ...more >>

Configuration: Sql server running on a test machine with mirrored drive for OS and SAN for data. Problem: A week ago a mirrored drive went down. We reconfigured the drive and updated the drivers on the drive. About the same time the backups stopped running. The sqlagent reported errors...more >>

www.bootstraptech.com Bootstrap Technologies Private Limited, Global Systems integration and IT Services Company with a Focus on Enterprise Applications Space looking for Aggressive offshore expansion plans for their Hyderabad Development Centre. Bootstrap Technologies started Bootstrap Knowledg...more >>

I have just reloaded my PC with Vista Ultimate. I have installed SQL 2005 and I can not connect to the local DB. I can connect to remote DBs no problems. I have installed sp2 and had no issues. The error message I am getting is. TITLE: Connect to Server ------------------------------ Cann...more >>

Hi, I have a named instance of SQL Server 2000 called VTMS on a server called VTMS which resides on a cluster. I am trying to connect to a database on VTMS from a webapp (URL http://reports) hosted on a server called RPT (ASP.Net 2.0) using Windows Authentication. When I publish thi...more >>

Dear Sir, Actually i want to ask, how to install the SQL Server Desktop Edition 2000 Client Tools only from the Command Prompt ? i have gone through the internet but all the responds were about SQL Server Desktop Edition 2005, and it does not work for SQL Server Desktop Edition 2000. I just ...more >>

Hello, I am trying to get info from a linked server, but the instance is not the default instance. I have tried: select *from myserver\myinstance.mydb.dbo.mytable but get a syntax error due to the backslash. How should I specify the instance I wish to use? Thanks in advance Dave...more >>

HI, Currently would like to migrate my server from Win 2000 running SQL 2000 to Win 2003 and SQL 2005. We do have 2 inhouse program and ACCPAC (accounting) pack accessing the SQL database. According to my 3rd party software house that changing to SQL 2005 the performance is slower compared to...more >>

SQL Server Spec SQL 2000, 8.00.2187 SP4 standard edition windows 2003 SP1 sqlserver driver 2000.86.1830.00 webserver windows 2003 r2, standard edition service pack2 sqlserver driver 2000.86.3959.00 we received "intermittance" Error Number -2147467259 (&H80004005) [DBNETLIB][Connection...more >>

The user interface for SQL 2005 Management Studio is strange when you're messing with a linked 2000 server default instance. Maybe this isn't supported. :-) In the Object Explorer, go to the Linked Servers item, right-click and select "New Linked Server". In the "Linked Server" box, gi...more >>

Oops, I accidentally put this in the wrong newsgroup the first time. I think this is a better location. Sorry for the double-post. I occasionally need to create or alter a view that references a linked server, where the linked server is not currently online (or my Internet connection...more >>

Recently, an application has been migrated from Powerbuilder 9.0 to Powerbuilder 10.5 Build 6662. This application uses an .INI file located in the Windows folder. The connection to the database, which has also been migrated from SQL 2000 to SQL 2005 is as follows: [database] DBMS=3DOLE DB...more >>

I am new to SQL Server, and using the Express edition. I can't seem to find the way to create relationships between tables. Any reference info will be appreciated. ...more >>

Hello there I've got this error when i tried to connect sql server from biztalk on another domain: provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server where can be the problem? ...more >>