Connecting to SQL server

Select * from ServerName.DatabaseName.OwnerOrSchema.Objectname

I tyied the way given above.But when im going to run it on query analizer it gives an error massege saying that

"Server 'JOY' is not configured for DATA ACCESS.'

How can i configure the particuler sever.

Thanks

Set the server configuration to allow remote connections.

Connecting to SQL Mobile within VS-2005

I am getting an error when I run my project within VS2005. I am trying to connect to a SQL Mobile (sdf) file thru code using a connection string. As soon as run my project within the VS2005 environment, I get the following error when the code tries to connect:
"The file is not a valid database file. An internal error has occurred. [,,,Databasename,,]"
The source of the error is: Microsoft SQL Server 2000 Windows CE Edition
Native Error of: 25011
I am am deploying to POcket PC 2003 SE Emulator.
This code worked fine in VS2003 with SQLCE 2.0. But I have now updated the projects to VS2005 and recreated the database sdf file within the VS2005 environment.
Could someone please help me ASAP?
Thanks.

There is no database compatibility between SQL CE 2.0 and SQL Mobile. Database created through one cannot be opened by other. In you case, since you have upgraded the project and re-created the database, you have SQL Mobile database. But your application still has references to SQL CE 2.0 provider. So now your application is trying to open a SQL CE 3.0 Database using SQL CE 2.0 provider; that’s the reason why in your error string you can see

The source of the error is: Microsoft SQL Server 2000 Windows CE Edition
Native Error of: 25011

In you application you need to remove the reference from 2.0 provider and add reference to 3.0 provider.

Thanks

-Mani

connecting to SQL express through VB

Hi all,

I have SQL server express edition 2005 installed on my computer and using VB in MS Access to run some queries. The VB function looks something like this..

Dim dataRS As New ADODB.Recordset
Dim cnnSQL As New ADODB.Connection

Set cnnSQL = New ADODB.Connection
cnnSQL.ConnectionString = "Provider=SQLNCLI;Server=.\SQLExpress;Database=TestDB;Trusted_Connection=yes;"

cnnSQL.Properties("Integrated Security").Value = "SSPI"
cnnSQL.Open

dataRS.Open "SELECT dbo_Table_1.* FROM dbo_Table_1", cnnSQL, adOpenStatic, adLockOptimistic

The code fails on the last line with message
"Invalid object name 'dbo_Table_1'"
(yes, I verified that the table actually does exist in the DB)

I must be doing something wrong with the connection string but all the things that I've tried so far haven't worked.. Can anyone offer any suggestions?

Thanks in advance,

Try providing the schema name for the table in your select statement, as in:

SELECT DBO.dbo_Table1.* FROM DBO.dbo_Table1

You schema may or may not be DBO, I just use that here as an example.

Mike

Connecting to SQL Express on a hosted site

Folks.

I just moved my domain to GoDaddy.com. When I run my website locally, everything works fine.

When I ftp it to my server space on GoDaddy.com, I get a "remote connection" error. Does anyone have an example of a connection string I should be using to connect while on the server?

Thanks!

From looking at their website, they do not appear to offer SQL Server2005 or SQL Server 2005 Express. That'd be why you're getting theerror you are. I'm getting the same dang thing on my hostingservice - 1PlanHost.com. They, for some reason, will not installSQL Express... even though ALL of these starter kits, etc. are using itby default. It's making things quite bothersome for us developers!

If anyone figures out a way to force SQL Express to run within a shared hosting enviroment, let me know!|||

Thanks for your response. GoDaddy does offer SQL Server. You can configure it once you have purchased a hosting package. What they don't offer is any incling of support for it. If I find anything out, I'll let you know.

sqlsql

Connecting to remote SQL server problems

I'm trying to run a report in VB 6 and having a heck of a time. I think my major problem right now is that it doesn't know where I'm trying to connect to and with which credentials. I've looked thru k.babu's sticky thread, but haven't found a solution.

Here is the code I have right now:

Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
Screen.MousePointer = vbDefault
With Report
.ParameterFields(1).ClearCurrentValueAndRange
.ParameterFields(1).AddCurrentValue "KL"
.Database.LogOnServer "p2ssql.dll", "tsg2170", "tableName", "username", "password"
End With
CRViewer1.ViewReport
End Sub

I don't have a clue what to do. BTW, this is my first attempt at anything with crystal in VB.

The error I'm getting is:
Login Failed.
Details: ADO error code: 0x80040e4d
Source: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user 'username'.
SQL State: 42000
Native Error: 18456

I know the username/password are correct.Here is my solution

Private Sub Form_Load()
Dim CRXReport As CRAXDDRT.Report
Dim CRXDb As CRAXDDRT.Database
Dim CRXTbl As CRAXDDRT.DatabaseTable
Dim init As Integer

Set CRXReport = Report
Set CRXDb = CRXReport.Database

CRXReport.DiscardSavedData

init = 1
Do Until init = CRXReport.Database.Tables.Count + 1
CRXReport.Database.Tables.Item(init).SetLogOnInfo "tsg2107", "sedonaMM", "username", "password"
init = init + 1
Loop

With frmMain
.Show
CRXReport.ParameterFields(1).AddCurrentValue "LH"
With CRXReport
.ExportOptions.DestinationType = crEDTDiskFile
.ExportOptions.DiskFileName = "C:\LHReport.pdf"
.ExportOptions.FormatType = crEFTPortableDocFormat
End With
.CRViewer1.ReportSource = CRXReport
CRXReport.Export False
End With

Set CRXReport = Nothing
End Sub

Connecting to multiple SQLserver

Hello,

I am working on to design SSIS package which need to run scripts against multiple sqlserver and need help.

Basically I need to connect several SQLserver machine to get a data and insert to our central respository.

Any help or tip appreciated.

Thanks

--

Farhan

Farhan H Soomro wrote:

Hello,

I am working on to design SSIS package which need to run scripts against multiple sqlserver and need help.

Basically I need to connect several SQLserver machine to get a data and insert to our central respository.

Any help or tip appreciated.

Thanks

--

Farhan

Use multiple connection managers.

-Jamie

|||Is there any way I can read from text file salserver name and connect to particular server and run the scripts?|||

Farhan H Soomro wrote:

Is there any way I can read from text file salserver name and connect to particular server and run the scripts?

Yes. SSIS Configurations are provided to help you do exactly this.

Creating Package Configurations
(http://msdn2.microsoft.com/en-us/library/ms141132.aspx)

-Jamie

|||

If you have a list of servers that you want to run some SQL against, you can create two packages.

The simplest way to do this is create a SQL Server configuration table.
In the first package create a ForEach loop that processes each server in a resultset (I'd stick the list of servers in a SQL table so you can use it in reports).
In the ForEach loop
execute a SQL task to update the connection for the second package (the source server connection).
Then execute the second Package

In the Second package just create two connections, the source server to run the scripts against and the destination server to put the results in. Just use a data flow task to move the data.

|||

Thanks for the help. Just wondering how to setup SQL task to update the connection for the second package ?

TIA

--

Farhan

connecting to 2 databases inside one query

hi there,
I saw a similar thread before but i've tried it and no luck. I want run a query off a database (stawebdata.branchinfo) then a join into bluepages.phonelist

i've tired

JOIN bluepages.phonelist p

Incorrect syntax near the keyword 'JOIN'.

any ideas... is this possible?

complete code below:

select DISTINCT b.name, b.tel1, b.id, b.telprivate,b.sc, b.manager,b.branchEmail
from branchInfo b
inner
JOIN bluepages.phonelist p on b.name = p.subdepartment
where b.name like 'Sarah' or b.id LIKE '%@.keyword%' OR b.county LIKE '%@.keyword%' OR b.Area LIKE '%@.keyword%' OR b.Manager LIKE '%@.keyword%' OR b.AssistantManager LIKE '%@.keyword%' OR b.Postcode LIKE '%@.keyword%' OR b.PseudoCity LIKE '%@.keyword%' OR b.TicketingTA LIKE '%@.keyword%' OR b.SLC LIKE '%@.keyword%' OR b.ItineraryTA LIKE '%@.keyword%' OR b.TIDS LIKE '%@.keyword%' OR b.ABTA LIKE '%@.keyword%' and
p.department = 'UK Branch' and
b.isbranch <> 'False' or
(p.lastName = '@.keyword' or p.firstname = '@.keyword')
order by b.name asc
GOyou have to put

JOIN bluepages.dbo.phonelist

i thought "dbo" was a param!

derrr|||How about putting two dots:

JOIN bluepages..phonelist

Roshmi Choudhury

Connecting through Enterprise Manager

Hi
I am running Win2k Server on an XP machine. I have two
databases which I can run programs on with no problem. I
can connect and run queries through Query Analyzer with
no problem, but when i open Enterprise Manager to access
the Databases, the DB service stops and then I get the
message "The Connection to SQL Server has been broken.
The connection to the SQL Server is broken. Do you want
to try reconnecting to it?" I answer yes, and the prompt
for reconnecting keeps coming up. I can't access any of
my DB's through Enterprise manager. When I try to attach
a DB through the All Tasks option I get "Error 22528 [SQL-
DMO]This server connection has been unexpectedly broken
and cannot be reconnected."
Any ideas on what I need to do to rectify this problem?
Thanks
Dave LugoCheck your SQL errorlog to see if you have any stack dumps.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Connecting through Enterprise Manager

Hi
I am running Win2k Server on an XP machine. I have two
databases which I can run programs on with no problem. I
can connect and run queries through Query Analyzer with
no problem, but when i open Enterprise Manager to access
the Databases, the DB service stops and then I get the
message "The Connection to SQL Server has been broken.
The connection to the SQL Server is broken. Do you want
to try reconnecting to it?" I answer yes, and the prompt
for reconnecting keeps coming up. I can't access any of
my DB's through Enterprise manager. When I try to attach
a DB through the All Tasks option I get "Error 22528 [SQL-
DMO]This server connection has been unexpectedly broken
and cannot be reconnected."
Any ideas on what I need to do to rectify this problem?
Thanks
Dave Lugo
Check your SQL errorlog to see if you have any stack dumps.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Connecting Surface Area Configuration to server on Clustered Server

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error:

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)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

Can anyone give me a little help here - I can't make configuration changes on production servers.

Thanks.

|||

Well, after a lucky break I found the answer.

sp_configure 'remote admin connections', 1
go
reconfigure
go

Once this was executed on the server I was able to go into Surface Area Configuration, enter the virtual server name, and connect successfully and make the other changes necessary. A simple solution to a scary problem. (Even though I'd used sp_configure for years on both Sybase and MSSQL servers it's easy to forget about the simple solutions.)

Connecting Surface Area Configuration to server on Clustered Server

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error:

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)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

Can anyone give me a little help here - I can't make configuration changes on production servers.

Thanks.

|||

Well, after a lucky break I found the answer.

sp_configure 'remote admin connections', 1
go
reconfigure
go

Once this was executed on the server I was able to go into Surface Area Configuration, enter the virtual server name, and connect successfully and make the other changes necessary. A simple solution to a scary problem. (Even though I'd used sp_configure for years on both Sybase and MSSQL servers it's easy to forget about the simple solutions.)

|||thx a lot

Connecting SQL server to the net?

Hi all. Im using Visual Web developer 2005 and have successfully connected my SQL Server to Visual Web developer website. When i run it locally, its fine. But, i now would like the site to be placed on the net - but im not sure how to connect it properly in the webhost. Can someone tell me how this is done please, or a link? cheers.

You can add a connection string on web.config file

<connectionStrings>

<add name="connectioname" connectionString="server=database server;uid=username; pwd=pasword; database=databasename;"/>

</connectionStrings>

then call this connection string on your page.

string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["connectionname"].ConnectionString;

I hope this will help.

|||

Ok.....im still rather confused on how exactly the databse is linked. Firstly, i have the site on a external harddrive....but ive found that the SQL server databse is placed in a totally different location - C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Database.mdf

Surely i would have to link it some how for the site/databse to work properly on the site?

|||No ideas guys? Surely there must be a way so i can upload my SQL server database and connect it to my website? I can do it easily in Visual Web Developer in my computer....but stummped how to do it on the net.....|||

Hi,

You may follow the steps below.

First, backup you local database.

Second, get the physical folder of the database file exist on your server. From your previous post, it isC:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL\Data\.

Third, restore your backup file to your server database. (Note, you have to replace theMove to Physical file nameitem in the Option tab with your real server-side database folder.)

Third, modify the connection string in your web.config file and call the string in your code by ConfigurationManager.

Thanks.

connecting samples to SQL Server 2005 Enterprise edition

ok, I've installed sql server, run the install samples and database, but when I go into SQL Server, the database and samples are not there. How do I connect the two?

thx,

Kat

Right click on the database node --> Attach database --> point to the data directorx where the samples have been installed --> Done.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Connecting RS to another server

When I run an RS report on server1 that connects to a sql database on server2
I get the error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "
Suggestions?On Jun 7, 1:50 pm, Jimbo <J...@.discussions.microsoft.com> wrote:
> When I run an RS report on server1 that connects to a sql database on server2
> I get the error:
> "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "
> Suggestions?
Refer to Reeves Smith's response to your other posting. That would be
my suggestion as well.
Regards,
Enrique Martinez
Sr. Software Consultant

Connecting a node in cluster

I have 2-node cluster. I can connect to the cluster from
enterprise manager. However, due to some reason, the
administrator wants to run enterprise manager connecting
to an instance on a node rather than cluster. How do we do
it?
I am not usre what you are asking. If you want to connect to the virtual
SQL Server from a machine other than the nodes of the cluster, you just
specify the virtual SQL Server name when registering the SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Inform the Administrator that you need to connect to the Virtual Server,
not the node itself.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connecting a node in cluster

I have 2-node cluster. I can connect to the cluster from
enterprise manager. However, due to some reason, the
administrator wants to run enterprise manager connecting
to an instance on a node rather than cluster. How do we do
it?I am not usre what you are asking. If you want to connect to the virtual
SQL Server from a machine other than the nodes of the cluster, you just
specify the virtual SQL Server name when registering the SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Inform the Administrator that you need to connect to the Virtual Server,
not the node itself.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connect to SQL2000 & SQL 2005

Our current program use ADO to connect oto SQL2000 and run fine.
We are planning to migrate to SQL2005.
When we clean install the SQL2005, create the database, set compatibility
level to 80 and generate the db structure, and migrate data.
When everything is done, we try to use our program to connect to SQL2005
database and find the connection fail.
Even when we use sa as login user and still fail to connect.
Is there any different in connection for SQL2000 & SQL2005?
I remember I have tried upgrade SQL2000 to SQL2005 before and the connection
had no problem to sql2005.
Is there something I forgot to set?
KanAm Tue, 29 Aug 2006 17:38:51 +0800 schrieb Ivan:

> Our current program use ADO to connect oto SQL2000 and run fine.
> We are planning to migrate to SQL2005.
> When we clean install the SQL2005, create the database, set compatibility
> level to 80 and generate the db structure, and migrate data.
> When everything is done, we try to use our program to connect to SQL2005
> database and find the connection fail.
> Even when we use sa as login user and still fail to connect.
> Is there any different in connection for SQL2000 & SQL2005?
> I remember I have tried upgrade SQL2000 to SQL2005 before and the connecti
on
> had no problem to sql2005.
> Is there something I forgot to set?
> Kan
If you did a standard installation then SQL2005 uses the named instance
SQLExpress wich you have to use in your connect string.
If your SQL2005 runs on the same machine as your SQL2000 then maybe SQL2005
listen on another port than the standard port.
And have you allowed remote access in SQL2005?
bye, Helmut|||No, MDAC will work fine with the SQL Server 2005 instance. Although you
can=B4t use some of the new cool features its compatible. Which error do
you get ? Is the SQL Server 2k5 located on the same machine as the 2k
instance ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

connect to sql server 2005 problem

I tried to run MS SQL server management studio with sa login. But it gives
an error as following:
Cannot connect to the server:
Additional information:
A connection waas successfully established with the server, but then an
error occured during the
login process. (provider: Shared Memory Provider, error:0 - No process is on
other end of the
pipe.) (Microsoft SQL Server, error:233)
Does anyone know what is the problem and how to fix it? THanksHi
"00MichaelJordan" wrote:
> I tried to run MS SQL server management studio with sa login. But it gives
> an error as following:
> Cannot connect to the server:
> Additional information:
> A connection waas successfully established with the server, but then an
> error occured during the
> login process. (provider: Shared Memory Provider, error:0 - No process is on
> other end of the
> pipe.) (Microsoft SQL Server, error:233)
I assume you are on the server itself when you try and connect? Can you
sucessfully connect using windows authentication?
Checking Google for your error message came up with:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
Check the client and server protocols installed. Check any antivirus or
intrusion detection systems installed on the server is not interferring.
> Does anyone know what is the problem and how to fix it? THanks
>
John|||Yes, I can login with window authentication.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DDB7F0E-DE41-467C-8A7E-1BAF6EBBEDF1@.microsoft.com...
> Hi
> "00MichaelJordan" wrote:
>> I tried to run MS SQL server management studio with sa login. But it
>> gives
>> an error as following:
>> Cannot connect to the server:
>> Additional information:
>> A connection waas successfully established with the server, but then an
>> error occured during the
>> login process. (provider: Shared Memory Provider, error:0 - No process is
>> on
>> other end of the
>> pipe.) (Microsoft SQL Server, error:233)
> I assume you are on the server itself when you try and connect? Can you
> sucessfully connect using windows authentication?
> Checking Google for your error message came up with:
> http://msdn2.microsoft.com/en-us/library/ms175496.aspx
> http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
> Check the client and server protocols installed. Check any antivirus or
> intrusion detection systems installed on the server is not interferring.
>> Does anyone know what is the problem and how to fix it? THanks
> John|||Hi
On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> Yes, I can login with window authentication.
>
You don't say if this is a local or remote connection!
Have you tried creating a new SQL Server Login and tried to use that?
Have you set the default database for sa?
Has this databases been moved from a different machine?
John|||John,
This is a local connection. The default database for sa is
master and I have created a new sql server account and I cannot login with
the new account as well and this database is moved from a SQL 2000 server.
Please help. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1170405046.429970.295550@.s48g2000cws.googlegroups.com...
> Hi
> On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
>> Yes, I can login with window authentication.
> You don't say if this is a local or remote connection!
> Have you tried creating a new SQL Server Login and tried to use that?
> Have you set the default database for sa?
> Has this databases been moved from a different machine?
> John
>
>|||Hi
On Feb 6, 3:08 am, " 00EricClapton" <E...@.yahoo.com> wrote:
> John,
> This is a local connection. The default database for sa is
> master and I have created a new sql server account and I cannot login with
> the new account as well and this database is moved from a SQL 2000 server.
> Please help. Thanks.
>
As you can log in with windows authentication then make sure that the
server is set to used mixed mode. Are you using Query Analyser to log
in? Try using the server's IP address instead of the server name,
'(local)' or '.'. You could also try removing the shared memory
setting on the protocol.
John

connect to sql server 2005 problem

I tried to run MS SQL server management studio with sa login. But it gives
an error as following:
Cannot connect to the server:
Additional information:
A connection waas successfully established with the server, but then an
error occured during the
login process. (provider: Shared Memory Provider, error:0 - No process is on
other end of the
pipe.) (Microsoft SQL Server, error:233)
Does anyone know what is the problem and how to fix it? THanks
Hi
"00MichaelJordan" wrote:

> I tried to run MS SQL server management studio with sa login. But it gives
> an error as following:
> Cannot connect to the server:
> Additional information:
> A connection waas successfully established with the server, but then an
> error occured during the
> login process. (provider: Shared Memory Provider, error:0 - No process is on
> other end of the
> pipe.) (Microsoft SQL Server, error:233)
I assume you are on the server itself when you try and connect? Can you
sucessfully connect using windows authentication?
Checking Google for your error message came up with:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
Check the client and server protocols installed. Check any antivirus or
intrusion detection systems installed on the server is not interferring.

> Does anyone know what is the problem and how to fix it? THanks
>
John
|||Yes, I can login with window authentication.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DDB7F0E-DE41-467C-8A7E-1BAF6EBBEDF1@.microsoft.com...
> Hi
> "00MichaelJordan" wrote:
>
> I assume you are on the server itself when you try and connect? Can you
> sucessfully connect using windows authentication?
> Checking Google for your error message came up with:
> http://msdn2.microsoft.com/en-us/library/ms175496.aspx
> http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
> Check the client and server protocols installed. Check any antivirus or
> intrusion detection systems installed on the server is not interferring.
>
> John
|||Hi
On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> Yes, I can login with window authentication.
>
You don't say if this is a local or remote connection!
Have you tried creating a new SQL Server Login and tried to use that?
Have you set the default database for sa?
Has this databases been moved from a different machine?
John
|||John,
This is a local connection. The default database for sa is
master and I have created a new sql server account and I cannot login with
the new account as well and this database is moved from a SQL 2000 server.
Please help. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1170405046.429970.295550@.s48g2000cws.googlegr oups.com...
> Hi
> On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> You don't say if this is a local or remote connection!
> Have you tried creating a new SQL Server Login and tried to use that?
> Have you set the default database for sa?
> Has this databases been moved from a different machine?
> John
>
>
|||Hi
On Feb 6, 3:08 am, " 00EricClapton" <E...@.yahoo.com> wrote:
> John,
> This is a local connection. The default database for sa is
> master and I have created a new sql server account and I cannot login with
> the new account as well and this database is moved from a SQL 2000 server.
> Please help. Thanks.
>
As you can log in with windows authentication then make sure that the
server is set to used mixed mode. Are you using Query Analyser to log
in? Try using the server's IP address instead of the server name,
'(local)' or '.'. You could also try removing the shared memory
setting on the protocol.
John

connect to sql server 2005 problem

I tried to run MS SQL server management studio with sa login. But it gives
an error as following:
Cannot connect to the server:
Additional information:
A connection waas successfully established with the server, but then an
error occured during the
login process. (provider: Shared Memory Provider, error:0 - No process is on
other end of the
pipe.) (Microsoft SQL Server, error:233)
Does anyone know what is the problem and how to fix it? THanksHi
"00MichaelJordan" wrote:

> I tried to run MS SQL server management studio with sa login. But it gives
> an error as following:
> Cannot connect to the server:
> Additional information:
> A connection waas successfully established with the server, but then an
> error occured during the
> login process. (provider: Shared Memory Provider, error:0 - No process is
on
> other end of the
> pipe.) (Microsoft SQL Server, error:233)
I assume you are on the server itself when you try and connect? Can you
sucessfully connect using windows authentication?
Checking Google for your error message came up with:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
http://blogs.msdn.com/sql_protocols.../22/483684.aspx
Check the client and server protocols installed. Check any antivirus or
intrusion detection systems installed on the server is not interferring.

> Does anyone know what is the problem and how to fix it? THanks
>
John|||Yes, I can login with window authentication.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:2DDB7F0E-DE41-467C-8A7E-1BAF6EBBEDF1@.microsoft.com...
> Hi
> "00MichaelJordan" wrote:
>
> I assume you are on the server itself when you try and connect? Can you
> sucessfully connect using windows authentication?
> Checking Google for your error message came up with:
> http://msdn2.microsoft.com/en-us/library/ms175496.aspx
> http://blogs.msdn.com/sql_protocols.../22/483684.aspx
> Check the client and server protocols installed. Check any antivirus or
> intrusion detection systems installed on the server is not interferring.
>
> John|||Hi
On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> Yes, I can login with window authentication.
>
You don't say if this is a local or remote connection!
Have you tried creating a new SQL Server Login and tried to use that?
Have you set the default database for sa?
Has this databases been moved from a different machine?
John|||John,
This is a local connection. The default database for sa is
master and I have created a new sql server account and I cannot login with
the new account as well and this database is moved from a SQL 2000 server.
Please help. Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1170405046.429970.295550@.s48g2000cws.googlegroups.com...
> Hi
> On Feb 2, 12:09 am, "00MichaelJordan" <M...@.yahoo.com> wrote:
> You don't say if this is a local or remote connection!
> Have you tried creating a new SQL Server Login and tried to use that?
> Have you set the default database for sa?
> Has this databases been moved from a different machine?
> John
>
>|||Hi
On Feb 6, 3:08 am, " 00EricClapton" <E...@.yahoo.com> wrote:
> John,
> This is a local connection. The default database for sa is
> master and I have created a new sql server account and I cannot login with
> the new account as well and this database is moved from a SQL 2000 server.
> Please help. Thanks.
>
As you can log in with windows authentication then make sure that the
server is set to used mixed mode. Are you using Query Analyser to log
in? Try using the server's IP address instead of the server name,
'(local)' or '.'. You could also try removing the shared memory
setting on the protocol.
John