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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|