Hi,
I couldn't do a connection a database SQL per ODBC, the system send me a
message:
Connection Failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen(Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
or access denied.
I'd like to do a databese using SQL,
What can I do?
I'm using a Windows 2000 Profesional, Service Pack 4.
Thanks.
Did you check your client/server connection manager and make sure that tcpIP
is enabled on the sql server and that port 1433 is allowed through any kind
of firewall?
You can find these settings under program files-->sql server on your the
computer running sql server.
Here is a solid article...
http://sqljunkies.com/HowTo/2E1101E0-D5C1-4DBD-A398-FE485DFA439B.scuk
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.TechIntSolutions.com
www.RealWorldSQL.com
*/
"Freddy" <Freddy @.discussions.microsoft.com> wrote in message
news:4012E460-2922-43D6-B0D6-3A88610DCDDA@.microsoft.com...
> Hi,
> I couldn't do a connection a database SQL per ODBC, the system send me a
> message:
> Connection Failed:
> SQLState: '01000'
> SQL Server Error: 2
> [Microsoft][ODBC SQL Server Driver][Shared
> Memory]ConnectionOpen(Connect()).
> Connection Failed:
> SQLState: '08001'
> SQL Server Error:17
> [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
> exist
> or access denied.
> I'd like to do a databese using SQL,
> What can I do?
> I'm using a Windows 2000 Profesional, Service Pack 4.
> Thanks.
>
|||Hi Warren,
Maybe I didn't explain correctly. I would like to do a Local connection
with a database, trought OBDC using SQL. I was cheking the article but it
don't help me.
I tried with:
Open a Wimdow (SQL Server Service Manager) and I tried to start the
MSSQLServer, but send me a message: Your SQL installation is either corrupt
or has been tampered with (unknown packege id). Please rerun Setup.
I hope that you are understand me.
Thanks.
"Warren Brunk" wrote:
> Did you check your client/server connection manager and make sure that tcpIP
> is enabled on the sql server and that port 1433 is allowed through any kind
> of firewall?
> You can find these settings under program files-->sql server on your the
> computer running sql server.
> Here is a solid article...
> http://sqljunkies.com/HowTo/2E1101E0-D5C1-4DBD-A398-FE485DFA439B.scuk
> --
> /*
> Warren Brunk - MCITP,MCTS,MCDBA
> www.TechIntSolutions.com
> www.RealWorldSQL.com
> */
>
> "Freddy" <Freddy @.discussions.microsoft.com> wrote in message
> news:4012E460-2922-43D6-B0D6-3A88610DCDDA@.microsoft.com...
>
>
Thursday, March 8, 2012
Connection Failed
Labels:
01000sql,
amessageconnection,
connection,
couldnt,
database,
error,
failed,
failedsqlstate,
microsoft,
mysql,
odbc,
oracle,
server,
sql,
system
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment