SQL Server 2005

MS SQL SERVER

    Sponsored Links

    Next

  • 1. How to import data
    I am new to SQL server 2000. I want to make a database in SQL server. The data that I have is in a text file having field names at the top and the data is line by line delimited by pipe. I dont know how to upload the data and make a database. Any idea. Please help. Thanks.
  • 2. Recognizing new second processor
    We have recently added a second processor to our database server. Is there a method available to have SQL Server 2000 recognize the existance of the second processor or will I have to reload the program. Thanks in advance. Craig
  • 3. chkdsk error after installing SP4 for SQL7
    I'm getting the following error after installing SQL7 SP4 on an NT4 system whenever I run chkdsk "CHKDSK detected minor inconsistancies on the drive" chkdsk /f doesn't seem to fix it, and it doesn't appear until after the machine reboots following the SP install. Anyone else seen this problem or know how to fix it?
  • 4. Server Agent Startup
    Hello, SQL Server starts up with my computer, but not SQL Server Agent. There doesn't seem to be an option to allow this. Can someone help me set the Server agent to start automatically? God Bless, Mark A. Sam

SQL Server 2005

Postby vul » Wed, 30 Nov 2005 06:57:52 GMT

I have SQL Server 2000 installed on my workstation. I'm using EM to work 
with databases on hosting servers (my WEB sites are using SQL Server DBs). 
Will I be able to continue to work with SQL Server 2000 databases (create 
tables, SPs etc) if I'll install SQL Server 2005 on my machine?
Or If I'll create something from SQL Server Management Panel it's not going 
to work?

Thank you
Al 



Re: SQL Server 2005

Postby Erland Sommarskog » Wed, 30 Nov 2005 19:25:41 GMT

vul ( XXXX@XXXXX.COM ) writes:

You can install SQL 2005 and EM will continue to work. But you cannot 
access SQL 2005 from EM. (Query Analyzer works.)

You can also use Mgmt Studio to access SQL 2000.

-- 
Erland Sommarskog, SQL Server MVP,  XXXX@XXXXX.COM 

Books Online for SQL Server 2005 at
 http://www.**--****.com/ 
Books Online for SQL Server 2000 at
 http://www.**--****.com/ 

SQL Server 2005

Postby Q2hlbg » Sun, 29 Jan 2006 04:26:28 GMT

Hi,

In our production site, we used SQL Server 2000 Enterprise Edition. In the 
future I will upgrade to SQL Server 2005; so now I need to do some test on 
SQL Server 2005. My question is which product equivalent SQL Server 2000? Is 
that the SQL Server 2005 Express Edition or SQL Server 2005 Enterprise 
Edition?

Thanks!


Re: SQL Server 2005

Postby Jasper Smith » Sun, 29 Jan 2006 06:50:16 GMT

You need SQL Server 2005 Enterprise Edition (for development/testing 
purposes you could also use Developer Edition which is functionally 
equivalent to Enterprise Edition but not licensed for production use)

-- 
HTH,
Jasper Smith (SQL Server MVP)
 http://www.**--****.com/ 









Re: SQL Server 2005

Postby YWRz » Fri, 03 Feb 2006 15:00:28 GMT

hi Jasper,

Which version of sql server 2005 has the management studio?i have sql server 
2005 express edition included in the visual studio 2005 and the sql server 
2005 developer edition (CTP). what i can see after the installation are 
configuration tools but no management studio.

Thanks in advance

Ads








Re: SQL Server 2005

Postby Sue Hoegemeier » Sat, 04 Feb 2006 13:50:18 GMT

Developer Edition has Management Studio.
Express Edition does not. There is a CTP available for
Management Studio Express:
 http://www.**--****.com/ 

-Sue

On Wed, 1 Feb 2006 22:00:28 -0800, ads









SQL Server 2005

Postby saw » Fri, 08 Feb 2008 04:42:52 GMT

Hello,

I have an application that requires an database to be installed on the same 
machine as a backend database.  I downloaded SQL Server 2005 as well as the 
SQL SERVER TOOLS 5.

Since the application as well as the sql are on the same machine I am 
receiving error message as follows:

[SQL Native Client]Shared Memory Provider: No process is on the other end of 
the Pipe. [SQL Native Client] Communication Link Failure.

At the bottom right side I don't the icon that the SQL Server is running 
however within the services it is running.

No client will be connected to this server as it is purely a lab 
environment.

Could you also tell me how to test the ODBC as well as how to test SQL 
Server?

Thank you. 



Re: SQL Server 2005

Postby Ross Mistry » Fri, 08 Feb 2008 08:10:17 GMT

Comments Below

Ross Mistry






Not Recommended, however, it is fine provided that you don't run into 
performance issues.

This is a depreciated feature as of SQL Server 2005. If the services are 
running then you should be in good shape.
Create an ODBC Connection, select the desired SQL Server, Database, provide 
credentials (Windows or SQL Mixed) and click Test Connection)




Re: SQL Server 2005

Postby Ross Mistry » Fri, 08 Feb 2008 08:16:27 GMT

Additonal thoughts, you should be able to connect to SQL Server via SQL 
Server Management Studio.  This will provide you with whether or not SQL 
Server is operational and if you can connect to the server at least locally. 
If you cannot connect let me know what error messages you receive in your 
logs (SQL Server and Event Viewer)












Re: SQL Server 2005

Postby saw » Fri, 08 Feb 2008 10:15:14 GMT

Misty:

Using your recommendation, I was sucessful in resolving the prior issue. 
But now, I am facing this issue,

When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server
Management Studio Express, I get the following error:

Cannot connect to (SERVER NAME) which both are on the same machine, I am
using one machine for everything since it is a lab machine.

Additional Information:
A connection was successfully established with the server, but then an error
occurred during the login process.  (provider: Shared Memory Provider,
error: 0 - No process is on the other end of the pipe.)  (Microsoft SQL
Server, Error: 223)

This error prevents my application on the same server machine from
connecting to the sql server on the same machine.

Please let me know what I can do to correct the issue.

Your help is greatly appreciated.












Re: SQL Server 2005

Postby Ross Mistry » Fri, 08 Feb 2008 10:28:52 GMT

or clarifications, stricktly running SQL Server 2005 Express on this
machine, correct?

Thanks

Ross
"saw" <swexpress(remove)@hotmail.com> wrote in message
news:% XXXX@XXXXX.COM ...



Re: SQL Server 2005

Postby saw » Fri, 08 Feb 2008 14:16:15 GMT

hank you for your reply.

No, I am only running SQL Server 2005. Actually, I removed the SQL Server
Express from the machine.

"Ross Mistry" < XXXX@XXXXX.COM > wrote in message
news:e% XXXX@XXXXX.COM ...



Re: SQL Server 2005

Postby Ekrem soy » Fri, 08 Feb 2008 17:47:33 GMT

i,

When you get this error, the reason of it is mostly using a wrong password
for your SQL Login. Ensure your password is correct. Users mostly say "I'm
sure it's correct!" However when I investigate the SQL Error Log, I see that
it says ""Login failed for user '...'. (Microsoft SQL Server, Error:
18456)". So the password is wrong...

--
Ekrem soy



"saw" <swexpress(remove)@hotmail.com> wrote in message
news:% XXXX@XXXXX.COM ...


Re: SQL Server 2005

Postby Ross Mistry » Sat, 09 Feb 2008 02:58:02 GMT


Based on my experience, this issue might also occur if maximum number of
concurrent connections has been reached.

To work around this issue, you can use the sp_configure Transact-SQL
procedure to increase the maximum number of concurrent connections. You can
also manage the instance of SQL Server 2005 in other ways. For example, you
can use the sqlcmd utility.

To use sp_configure to increase the maximum number of concurrent
connections, follow these steps:

1. Click Start, click Run, type cmd, and then click OK.

2. At the command prompt, type the following command, and then press
ENTER.

sqlcmd.exe -E -S servername\instancename

3. When you successfully connect to the instance of SQL Server 2005,
execute the following Transact-SQL statements at the SQL Server prompt.

sp_configure 'user connections', <NewNumber>
Go
Reconfigure
Go

0 means "unlimited" connections

4. Restart the SQL Server service for the change to take effect.

Note: The User connections option is an advanced setting. If you are using
the sp_configure system stored procedure to change the setting, you can
change user connections only when the Show advanced options setting is set
to 1. The setting takes effect after the server is restarted.


Also, you could change it from Management Studio directly

Right click the Server->Properties->Connections, and change "maximum number
of concurrent connections".

If the issue still occurs, please get the following to furhter troubleshoot:

1. collect SQL error log under and send it to me at XXXX@XXXXX.COM

C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG


2. Test to see if other protocals work propelry

sqlcmd.exe -E -S tcp:servername\instancename
sqlcmd.exe -E -S lpc:servername\instancename

Please refer to the following topic in BOL for more details about Sqlcmd
tool:

How to: Connect to the Database Engine Using sqlcmd.exe
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/74b0fb71-7f8e-4171-9431-d075
28532524.htm

3. Does the issue occurs consistently? If you restart the server, can you
still reproduce the problem?

If you have any update, please feel free to let's know. Thank you.
"Ekrem soy" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...



Re: Re: SQL Server 2005

Postby Siva Prasad » Tue, 08 Mar 2011 13:46:20 GMT

hen trying to connect to the SQL SERVER 2005 through Microsoft SQL Server
Management Studio Express, I get the following error:

Cannot connect to (SERVER NAME) which both are on the same machine, I am
using one machine for everything since it is a lab machine.

Additional Information:
A connection was successfully established with the server, but then an error
occurred during the login process. (provider: Shared Memory Provider,
error: 0 - No process is on the other end of the pipe.) (Microsoft SQL
Server, Error: 223)

This error prevents my application on the same server machine from
connecting to the sql server on the same machine.




















Similar Threads:

1.SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

Hi,
I was wondering what is the best practices for migrating existing DTS packages
over to Beta 2 of SQL Server 2005.
I am going to do "sandbox install" of SQL Server 2005 on Virtual PC 2004
and since I will have a clean install Im after ideas?

Thanks in advance
Dave

2.MCTS SQL Server 2005 & MCTS SQL Server 2005 Business Intelligence

Can anybody share there experiences of preparing for and taking these exams 
(70-431 and 70-445) to get these certifications (MCTS SQL Server 2005 & MCTS 
SQL Server 2005 Business Intelligence).
I am currently using Free MS online courses to prepare, should I invest in 
books MS recommend? Can I prepare for these exams using Books Online? 

Also the MCTS SQL Server 2005 Business Intelligence exam (70-445) is due for 
release next year. How do I register to take Beta exams in for this? When 
will these be ready?

Your help will be much appreciated.

3.Synchronising SQL Server 2005 mobile with SQL Server 2005 Express

Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 
(mobile and express).

I believe that I will need to write my own synchronization application, in 
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application when 
the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I 
just use a connection string from the Desktop machine, but which connects to 
the PDA DB??)
    - Once I have this connected, I presume I will be able to compare the 
data on the desktop machine, against the data on the PDA, and update each 
accordingly?

Any examples of this being done, or details of best practices for this would 
be much appreciated

Thanks 


4.SQL Server 2005 Express to SQL Server 2005 Standard

Hey,

I was wondering if it was easy to migrate from SQL Server 2005 Express
to SQL Server 2005 Standard?  If so, do you know how I can go about
doing the migration of data?  Thank you.

 

 

Sincerely,

 

Eldhose Cyriac

5.SQL Server 2005 EE DB auf SQL Server 2005

Hallo,

ich habe mal eine Frage bezlich einer Datenbank des SQL Server 2005
Express Edition...
Wenn ich mich entschlie damit eine Datenbank aufzubauen.. ist es im
nachhinein mlich diese auch mit dem gron Bruder SQL Server 2005 zu
verwalten (fnen/bearbeiten etc.)?

Danke und Gru
Juliane

6. SQL Server 2005 Compact Edition vs SQL Server 2005 Mobile Edition

7. migrate from SQL Server 2005 Express to SQL Server 2005 Standard

8. URGENT:Move databases in SQL server 2005 CTP to SQL Server 2005



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 27 guest