Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008


all groups > sql server connect > may 2006 > threads for may 8 - 14, 2006

Filter by week: 1 2 3 4 5

Local user XP -> remote XP
Posted by Damien at 5/14/2006 11:03:36 AM
HI Guys, Got the following scenario: Client machine: Windows XP Pro (SP2), logged in as local user Server machine: Windows XP Pro (SP2), running SQL Server 2000 both machines in same Domain. I am attempting to connect from the client to the server using SQL Server authentication, which i...more >>

upgrading db (SSE2005)
Posted by Erez Mor at 5/14/2006 10:27:01 AM
dear all i need to upgrade my client's db (the new mdf file has some new stored procedures). since the client has quite some data in the current version (and there is no way i can access the data myself), i thought that, after installing the new files, i'll open the old mdf file, and "select...more >>

ODBC Connection to SQL
Posted by Simon at 5/12/2006 1:17:02 AM
I have a network with 6 machines sitting on it. All PC`s are configued in the same way. 5 of the machines connect to a SQL server via ODBC with no problems. The sixth PC however does not connect to the server giving the following :- Connection Failed SQL State '01000; SQL Server Error: ...more >>

SQL 2005 Express - Limitations
Posted by Phil Williams at 5/12/2006 12:00:00 AM
Hello, What are the limitations for SQL 2005 Express. ie How many concurrent users can you have, what size database can you have etc. Where can I find this type of information? I have searched the MS site with success. Thanks in advance, Phil ...more >>

SQL Server 2k5 Local and Remote connections
Posted by msnews.microsoft.com at 5/11/2006 11:02:30 AM
I've installed SQL server 2k5 and all services on a WIN2k3 SR2 server as a named instance (SQL2k5_01) (There is no default instance and this is a brand new server), and while I was able to establish a local connection from the management studio I needed to type in the instance name after it l...more >>

HTTP Connection
Posted by webmaster at 5/10/2006 12:22:10 PM
Hi, I'm trying to simulate a pure HTTP connection between two SQL servers. I have 2 machines on the same LAN both running SQL Server 2000. On both machines I have turned on the firewalls and only allowed traffic on port 80. In the Client Network utility on one machine I create an alias f...more >>

SQL Server 2005 Express. Is it possible to connect under user different then SA?
Posted by Zam at 5/9/2006 10:56:15 PM
Hello World, Microsoft SQL Server Management Studio Express 9.00.2047.00 From ASP (ASP3) code, coudn't connect SQL Server 2005 Express (on the same local machine) Get error: Cannot connect to ..... Login Failed for user .... Error: 18456 Error occur, when try to connect under different...more >>

Can MSDE and SQL live on the same system?
Posted by Clayton Sutton at 5/9/2006 3:52:31 PM
Hey everyone, We are running MSDE on a Windows 200 server and it has data in it. What I would like to know is can we also install MSSQL 2005 on that server and have assess to both databases. Is there anything we have to do to install it and make sure it doesn't overwrite or delete the MSD...more >>



Connection Pooling & Users
Posted by Terry Holland at 5/9/2006 2:15:22 PM
I have an intranet application that comprises an ASP.Net application connecting to a SQL Server DB The application has 150 users. At the moment I am connecting using the following setup I have created a MyApp_WebUser user in SQL Server. My connection string, which is stored in my web.config...more >>

get Stored Procedures Parameters, how?
Posted by Tark Siala at 5/8/2006 8:32:29 PM
hi i make smal Application to get information from SQL Server 2000 by using VB6. now i can get Databases, Tables and Colomn, and Stored Procedures, but my problem how i can get SP Parametres? i am thinking to make small function to get Parametres From SP.Text, but i think its not good solut...more >>

Which programming is good for front end application to link to SQL
Posted by char at 5/8/2006 4:34:01 PM
Hi, I am trying to restructure the current system now. I would like to consult which programming is good for front end application to link to SQL DB? Thanks Char...more >>

SQL Server Cannot Connect to Local Instance
Posted by mannyc NO[at]SPAM gmail.com at 5/8/2006 3:58:35 PM
Hi, I have a SQL Server 2000 running on Win2k3. I uninstalled SharePoint so I could install Reporting Services and I upgraded to MDAC 2.8. I tried connecting to SQL locally on the Enterprise Manager on the machine but I get this error: "Server does not exist or access is denied." The odd th...more >>


DevelopmentNow Blog