Showing posts with label uninstalled. Show all posts
Showing posts with label uninstalled. Show all posts

Saturday, February 25, 2012

Cannot connect to sqlexpress from ssmse (ctp)

I have been using sqlexpress for several months and decided to upgrade the ssmse to the november ctp version. I uninstalled the old ssmse and installed the november release from ctp.

I verified that the tcp/ip and named pipes are enable in the config manager. I attempted using these connection strings:

\sqlexpress, (local)\sqlexpress, or server name\sqlexpress

All fail with the following message:

Cannot connect to WALLY1\sqlexpress

--
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476


BUTTONS:

OK

We need a little more information to troubleshoot your problem.

Are you running SSMSE and SQLExpress on the same machine? Are you able to connect to SQLExpress using SQLCMD?

Thanks,
Dan

|||Try to connect either with TCP/IP or named-pipes enabled and not with both the options enabled.
I have had this problem before and when used named-pipes alone it resolved the problem and ensure the ALIAS is defined properly and you can ping the server.|||

Are you running everything from the same machine or are you trying to connect to a remote SQL Server?

Cheers,
Dan

Friday, February 10, 2012

Cannot connect SQL 2005 with OLE DB Provider for SQL Server

Cannot connect SQL 2005 with OLE DB Provider for SQL Server

MSSQL 2000 Utilities & MSDE was uninstalled.
After installation SQL 2005 Standard Full all connections was OK (tested).
Aftert restarting the computer I cannot connect to MSSQL with OLE DB Provider for SQL Server.
I try to connect from Delphi 5 SP2 (ADOConnection) and from MS Access 2003 SP2.

Error "SQL Server denied or does not exists or access denied"

Versions:
Windows Xp Pro SP 2
ADO/MDAC: 2.81.1117.0 (xpsp_sp2_rtm.040803-2158)
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Connection sting:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pwd;Data Source=GMSAlexHome;Initial Catalog=GMSSample;Application Name="GMS Office Tools Service Pack"

Question: how to connect to SQL 2005 with SQL DB Provider.
All old applications does not work.

On local machine when ServerName = 'localhost' or '.' - all OK.
When using SQL server name - error.
Before rebooting all was OK.

Thanks in advance.

If you try to connect from the local PC and it works fine, but does not work from the network then most likely SQL Server is not enabled to accept external network requests. Also if your server name contains instance name, then it also suppose to be specified in your connection string, like servername\instancename|||

On local computer connection avaible only as <localhost> and <.>.

There is no instance name and other sql servers.

SQLSRV Works more than 3 times slower than MSDE 2000 on small test DB (about 100 mb).

VERY many bugs in tools and very slow.... $(((

What comps in MS? I have P4 3MHz 1 Gb SATA - VERY slow.

Sory for digression.

|||

Do you compare performance based on exact same data and structure? If your indexes are not the same as in MSDE 2000 then you cannot compare performance.

About bugs. If you have any, you could report them here. If you do this and they really exist, I believe, it will help to improve product

|||

As Val mentioned, please double check using "SQL Server Configuration Manager" tool that your SQL instance has remote TCP and/or Named Pipe support enabled.

Also, please make sure that the Windows Firewall is not blocking the ports used by SQL Server. You can explicitly add TCP port 1433 to the exception list or you can add Sqlservr.exe program to the exception list (to ensure both TCP and Named Pipes are not blocked).

Jimmy Wu

Cannot connect remotely to MSDE2000

Hi
I uninstalled SQL7 from a machine and then installed
MSDE2000 (using setup disablenetworkprotocols=0
securitymode=sql sawpw=x)
I can connect localy without a problem but as soon as I
try and connect (via EM or even ODBC) remotely, I get a
network library error. I've tried connecting with TCP and
Named Pipes protocols.
Any ideas?
H
Hi,
As a first step, try to see if the tcp protocol really is enabled. Run
svrnetcn.exe on the MSDE box and make sure it is.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:2ae5901c4685b$49dc6630$a601280a@.phx.gbl...
> Hi
> I uninstalled SQL7 from a machine and then installed
> MSDE2000 (using setup disablenetworkprotocols=0
> securitymode=sql sawpw=x)
> I can connect localy without a problem but as soon as I
> try and connect (via EM or even ODBC) remotely, I get a
> network library error. I've tried connecting with TCP and
> Named Pipes protocols.
> Any ideas?
> H