|
|
|
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 |
Filter by week: 1 2 3 4 Access Upsizing Wizard connection problem Posted by Dale at 2/21/2006 4:29:27 PM I'm trying to use the Upsizing Wizard on an Access database to SQL Server
2005. When I try to create the database I get a popup - Microsoft SQL Server
Login - with the following information:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][OBDC SQL Server Driver][DBNETLI...more >>
SQL Server 2000 Instance connectivity Issues Posted by RajJar at 2/21/2006 7:42:46 AM Hello: I get the following error message when I try to do a ODBC connection:
Connection Failed:
SQL State: '01000'
SQL server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())
Connection Failed:
SQL State: '08001'
SQL Server Error: 6
[Microsoft][ODBC...more >>
How to restart remote SQL service with OSQL? Posted by Joao Rego at 2/21/2006 7:26:27 AM Hello,
I'm writing am OSQL command to stop and start a remote Database.
For the momente I use SHUTDOWN T-SQL command to stop the sevice:
osql -U user -P pwd -S RemoteServer\MyInstance -q "shutdown"
How do I restart the service?
Thanks for any help on this question.
Joao Rego
...more >>
SS2005: Max connections Posted by SQLCatz at 2/20/2006 9:40:28 AM Hello,
What is the maximum number of active connections in SS2005 on Windows
2003 DC?
Cheers
SQLCatZ
...more >>
Unable to connect to database via webservce Posted by Saira at 2/20/2006 12:25:47 AM Hi all
I have taken on a project from another developer and am experiencing some
problems.
To give some background, the application was running smoothly (client talks
to web service, web service goes to database, web service returns data,
client displays data).
We then upgraded to SQL Serve...more >>
Single User mode connection, Posted by Veasna Much at 2/20/2006 12:00:00 AM Dear sir/madam,
I have a problem with my database. I want to restore MASTER, MSDB
database. I have try to restore in normal mode but it doesn't allow, it
requier to connect start in Single user mode. Once I start the server by
command prompt "sqlservr.exe -m" and I reconnect using "sa" acco...more >>
SQL Server running on a different port. Posted by Clarkie at 2/20/2006 12:00:00 AM Hello!
I am trying to understand how connections are made to a SQL Server when the
server is running on a different port.
My SQL Server 2000 SP4 is configured to listen on port 465 for TCP/IP. I
used the server network utility. My client has no idea of this but still
manages to connect u...more >>
locked out Posted by jmoeller18 at 2/19/2006 3:40:37 PM after installing sql server 2005, i messed up the login settings.
I know can't login.
i didn't really understand what i was doing
short of uninstalling, reinstalling, do i have any options?
also do you know of a tutorial for installing (setting windows vs sql
authentication) and then se...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Remote Connectivity and Listening IP Posted by Elliot Rodriguez at 2/17/2006 2:32:52 PM I have been having a heck of a time connecting to a remote 2K5 instance from
my local Management Studio.
Each time I have tried to connect, regardless of the account, I have been
greeted with "SQL Server does not exist/access denied" errors.
I have configured the server to accept remote co...more >>
Bug ?->Can not make a new connection to SQL Server 2005 X64 Posted by Kiran at 2/17/2006 2:30:07 PM Can not make a new connection to SQL Server 2005 X64 until the SQL Server
service is restarted.
OS is Windows 2003 X64 Enterprise Edition all updates are applied.
This repeats every few hours. Server protocols enabled are TCP IP and Named
Pipes
Client protocols are Named Piped only.
The ...more >>
Remote Server using Enterprise Manager Posted by Hermawih at 2/17/2006 10:55:26 AM Hi,
please help
I am new with MS SQL Server.
I do not have any problem with my local server but has problem with remote
server.
I am trying to connect my SQL database in my internet site.
I want to design my database using "SQL Server Enterprise Manager" but I
have received this erro...more >>
Dbnetlib connectionopen(preloginhandshake()) error Posted by Heather at 2/17/2006 10:25:27 AM SQL 2000/SQL 2005(see below) running on Windows 2003 sp1, web server running
IIS 5.0 on Windows 2000 sp4.
Sometime in the first week of every month since at least Nov 2005, I get an
Dbnetlib connectionopen(preloginhandshake()) error. Connections to the
databases from the Web pages will be slo...more >>
Problem when connect to SQL Server 2005 (SQL Native Client + Named instance) Posted by yangrudy NO[at]SPAM 126.com at 2/16/2006 9:58:07 PM Hi,
I have an application which previous connect to SQL Server 2000.
Now, I installed SQL Server 2005, and try to conncet to it.
The previous connection string is:
sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword);
In order to support SQL Native Client driver in SQL Server 2...more >>
Complicated Connection Problem between ADP and SQL Server Posted by Geoffrey Barnes at 2/16/2006 4:20:27 PM About 3 years ago, I was told to create a SQL Server 2000 database for a
client of ours, and to set up an Access XP/2002 project (adp) front end that
would be used on their network to interact with the data. This database
needs to be updated every six months. Since there has been some "feature
...more >>
Connect with TCP Posted by Jason at 2/16/2006 1:57:27 PM Hello,
I hope I'm posting this in the right group.
I'm trying to connect to a network server running Sql Server 2005 Express
from vb 2005. I can connect to it when I use:
DATA SOURCE=<servername>\SQLEXPRESS;INITIAL CATALOG=<cat>;Integrated
Security=SSPI;
However I need to be able to conn...more >>
Multiple select statements in one query? Posted by Preacher Man at 2/16/2006 10:31:06 AM How can I run a select statement on data from a previous select statement
within the same query? In VFP I could select the data into a cursor and
then run the second select statement on the cursor. What is the best way to
get this to run properly?
Thanks.
...more >>
Network transactions not allowed Posted by Jan Eliasen at 2/15/2006 3:44:51 PM Hi
I am trying to use the SQL Adapter in BizTalk 2004 against a SQL
Server 2005. When trying to fire a stored procedure, I get the error
you can see in http://www.eliasen.dk/biztalk/SQLSERVER2005ERROR.jpg
Can anyone tell me what the cause of this can be? I have been to
"Add/Remove windows c...more >>
SQL Server 2005 and Express Login Passwords Posted by GG at 2/15/2006 2:46:27 PM Hello,
We have installed SQL Server 2005 Express on a Windows XP box. The
server instance's collation property is set to
'SQL_Latin1_General_CP1_CI_AS'. The collation for the databases we are
connecting to via our application is set to
'SQL_Latin1_General_CP1_CI_AS' as well.
However when l...more >>
SQL Server Express & Access 2000 ADP Posted by Murphy at 2/15/2006 3:49:41 AM Hi,
I have a legacy db that was run using MSDE with an Access 2K ADP front end,
all worked well.
I now need access to the db again and have downloaded and installed SQL
Server Express, I have also restored my database successfully and can view
the tables using the Studio Express product....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |