HOW TO CONNECTED MS SQL 2005?

I had just install MS SQL 2005 at my server computer ( OS windows 2000
server sp4). I have LAN in office with workgroup, and I have a problem
that I can't connect to MS SQL 2005 from client mechine. Previously, I
used MS SQL 2000 server.
Please anybody can help me to resolve this problem?
Regard's
Rudi H
Try this:
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"RUDI HARSONO" <binapusat@.nusa.net.id> wrote in message
news:%23k1wt7LJHHA.780@.TK2MSFTNGP03.phx.gbl...
>I had just install MS SQL 2005 at my server computer ( OS windows 2000
>server sp4). I have LAN in office with workgroup, and I have a problem that
>I can't connect to MS SQL 2005 from client mechine. Previously, I used MS
>SQL 2000 server.
> Please anybody can help me to resolve this problem?
> Regard's
> Rudi H
|||Arnie Rowland wrote:
> Try this:
> Configuration -Configure SQL Server 2005 to allow remote connections
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
>
thanks for your help...

HOW TO CONNECTED MS SQL 2005?

I had just install MS SQL 2005 at my server computer ( OS windows 2000
server sp4). I have LAN in office with workgroup, and I have a problem
that I can't connect to MS SQL 2005 from client mechine. Previously, I
used MS SQL 2000 server.
Please anybody can help me to resolve this problem?
Regard's
Rudi HTry this:
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/defaul...kb;EN-US;914277
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"RUDI HARSONO" <binapusat@.nusa.net.id> wrote in message
news:%23k1wt7LJHHA.780@.TK2MSFTNGP03.phx.gbl...
>I had just install MS SQL 2005 at my server computer ( OS windows 2000
>server sp4). I have LAN in office with workgroup, and I have a problem that
>I can't connect to MS SQL 2005 from client mechine. Previously, I used MS
>SQL 2000 server.
> Please anybody can help me to resolve this problem?
> Regard's
> Rudi H|||Arnie Rowland wrote:
> Try this:
> Configuration -Configure SQL Server 2005 to allow remote connections
> http://support.microsoft.com/defaul...kb;EN-US;914277
>
thanks for your help...

How to connect to SQL Server 2000 and SQL Server 2005 in one computer??

Hi All!!!

In my Computer has MS SQL Server 2000(with default Instance) and now I Install MS SQL server 2005(with Instance name: SQL2005 ). Now I want to write Web Application to connect to the both databases (SQL Server 2000 and MS SQL Server 2005), How to Add connection string in my web.config to do it.

Help me ?

Thanks & Regards,

You can put the two connection strings in the web.config file and use either in your code..

|||

Hi !!!

Thanks for your support !!! Please give me the connection string to connect to SQL Server 2000 & SQL Server 2005.

Thanks

|||

check out www.connectionstrings.com

How to connect to my sql server express,also Pubs and northwind for sql server express

1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.
But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.
2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.
I have installed sample databases but can't find script for pubs and northwind nor it install automatically.
I wan't to use tutorial's sample.I have resolved the answer of the question's part 1.
Any Help regarding Part 2 ?????

How to connect to AS 2000

Hi all,

Currently I am working on the Window 2003 Enterprise 64-bit with SQL 2005 Enterprise and Visual Studio Professional install. I try to write a console application using Visual Studio to connect to the Analysis Server 2000, but I get the follow error message:

Errorystem.Runtime.InteropServices.COMException (0x800A0E7A): Provider cannot be found. It may not be properly installed.
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
at ExceptionCheck.Module1.Hodb03_ItemSales() in Z:\Visual Studio\Console\ExceptionCheck\ExceptionCheck\Module1.vb:line 16"

I know if I want to connect to the Analysis Service 2000, I need to install the Microsoft SQL Server 2000 PivotTable Services. After I install the services, I still get the error message.

Thanks,

Tomas

Hi,

Try to re-register msolap (regsvr32 msolap80.dll from "%ProgramFiles%\Common Files\System\Ole DB"). If you get the same error, let's check with the MDX Sample application (ships with AS2000, you can copy it from another machine). If you get the same error, then you probably have corrupted installation of the Pivot Table Service.

|||

Hi,

I tried to re-register msolap, but it didn't help.

|||The MDX Sample application failed with the same error ? Beside re-installing PTS, can't think of something else.

How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>

How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!
You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegro ups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>

How to connect instance on local server

hi!
I have a question about connecting instance on local server
I install MS SQL Server 2000 first
and then install MS SQL Server 2005.
2005 has an instance name called "2005"
I use Microsoft SQL Server Management Studio and log into 2000
I want to select data from 2005
so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
but it fail..
I also try following name
[local$2005].TESTDB.dbo.TEST but also fail
How can I connect these two SQL Server?
Can anyone give me a advice?
Thanks a lot!You can create a likned server between the two instances. register either
the 2000 in 2005 or the other way around. Once a linked server is created,
you can execute a query similar to this
SELECT something FROM [server\instance].db.schema.table
You can do a lot of things in here - create a network alias for an instance
name to make it simple if you don't want to use a server\instance name
calls, create a DNS entry that points to the instance name, etc.
"YesGoGoGo" <YesGoGoGo@.gmail.com> wrote in message
news:1185939323.853710.99990@.e16g2000pri.googlegroups.com...
> hi!
> I have a question about connecting instance on local server
> I install MS SQL Server 2000 first
> and then install MS SQL Server 2005.
> 2005 has an instance name called "2005"
> I use Microsoft SQL Server Management Studio and log into 2000
> I want to select data from 2005
> so I write a script "SELECT * FROM [local\2005].TESTDB.dbo.TEST
> but it fail..
> I also try following name
> [local$2005].TESTDB.dbo.TEST but also fail
> How can I connect these two SQL Server?
> Can anyone give me a advice?
> Thanks a lot!
>sql

how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?

how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?

how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?

How to configure SQL Server report server?

Hello, everyone
My company is planning to run SQL Server Service. We have SQL Server 2005. What softwares are needed to install on Report Server?
Thanks
ZYTHi ZYT

How detailed would you like your answer ?

This is a good link http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosqlserver2005.asp

Installation setup itself does quite a good job notifying you of Prerequisites

Basically Latest service Packs for the server & IIS for Reports Server

GW

How to completely remove MSDE

I need to completly remove MSDE from my PC it was installed using Install Shield Express and when I try to uninstall, I get a Fatal error durring installation. There must be a way other than reformatting?

Thank you,If you can tell me what the error said, then I'll be in a position to help you. But If it said something about some file not be able to be deleted, make sure it (MSDE) isn't running.

How to compare two versions of sqlserver?

HI,
I need to do an installer utility in which I have to install sql tables. In
there, I would need to check the version of sql server and add some
constraints if the sql server version is more than 8 and do alternate action
if its not.
Is there any function like version_compare()?
Thanks & Regards,
Celia
msnews wrote:
> HI,
> I need to do an installer utility in which I have to install sql tables. In
> there, I would need to check the version of sql server and add some
> constraints if the sql server version is more than 8 and do alternate action
> if its not.
> Is there any function like version_compare()?
> Thanks & Regards,
> Celia
>
>
There isn't a "out of the box" version compare function as such. I think
you'll have to use @.@.Version or SERVERPROPERTY and then use the result
you get from here to do your evaluation.
You can look up both options in Books On Line for further info and syntax.
Regards
Steen

How to compare two versions of sqlserver?

HI,
I need to do an installer utility in which I have to install sql tables. In
there, I would need to check the version of sql server and add some
constraints if the sql server version is more than 8 and do alternate action
if its not.
Is there any function like version_compare()?
Thanks & Regards,
Celiamsnews wrote:
> HI,
> I need to do an installer utility in which I have to install sql tables. I
n
> there, I would need to check the version of sql server and add some
> constraints if the sql server version is more than 8 and do alternate acti
on
> if its not.
> Is there any function like version_compare()?
> Thanks & Regards,
> Celia
>
>
There isn't a "out of the box" version compare function as such. I think
you'll have to use @.@.Version or SERVERPROPERTY and then use the result
you get from here to do your evaluation.
You can look up both options in Books On Line for further info and syntax.
Regards
Steen

How to compare two versions of sqlserver?

HI,
I need to do an installer utility in which I have to install sql tables. In
there, I would need to check the version of sql server and add some
constraints if the sql server version is more than 8 and do alternate action
if its not.
Is there any function like version_compare()?
Thanks & Regards,
Celiamsnews wrote:
> HI,
> I need to do an installer utility in which I have to install sql tables. In
> there, I would need to check the version of sql server and add some
> constraints if the sql server version is more than 8 and do alternate action
> if its not.
> Is there any function like version_compare()?
> Thanks & Regards,
> Celia
>
>
There isn't a "out of the box" version compare function as such. I think
you'll have to use @.@.Version or SERVERPROPERTY and then use the result
you get from here to do your evaluation.
You can look up both options in Books On Line for further info and syntax.
Regards
Steen

How to clean machine for SQL2005 Reporting Services RTM

hi all,

I am trying to get Reporting Services to install on a machine that previously had the September CTP install on it.

The SQL Server part of the install has been fine and all seems to be operational as expected but the Reporting Services fails to install with the following errors:

"An instance of the same name is already installed on this computer..."

This is thrown out of the ValidateInstanceName func in the MSI. I am telling it to use the Default Instance as there is only one SQL instance running (to my knowledge).

How do I clean up the machine so that it does not think another instance is present? I have tried MSIZAP and that has not helped. I have removed references from IIS, COM+, file system and registry.. but there must be some I am missing. Does anyone know what ValidateInstanceName is actually looking at/for?

Thanks
PaulIf in doubt..

Uninstall SQL Server 2005 and remove every reference to SQL (as far as possible) from the registry..

Fixed the issue.