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....HELP

How can I connect to database from a remote computer in the same domain?
I developed many database applications using Access, but now I need a code
snippet to make some of my existing application to run in a remote Sql server
with the same structure (databases, views)...and I can't figure how...
Anybody can help me?
http://www.able-consulting.com/ADO_Conn.htm
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:8E8F6961-D166-45D4-8C8E-3E3CD032B768@.microsoft.com...
> How can I connect to database from a remote computer in the same domain?
> I developed many database applications using Access, but now I need a code
> snippet to make some of my existing application to run in a remote Sql
server
> with the same structure (databases, views)...and I can't figure how...
> Anybody can help me?
sql

How to connect....HELP

How can I connect to database from a remote computer in the same domain?
I developed many database applications using Access, but now I need a code
snippet to make some of my existing application to run in a remote Sql serve
r
with the same structure (databases, views)...and I can't figure how...
Anybody can help me?http://www.able-consulting.com/ADO_Conn.htm
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:8E8F6961-D166-45D4-8C8E-3E3CD032B768@.microsoft.com...
> How can I connect to database from a remote computer in the same domain?
> I developed many database applications using Access, but now I need a code
> snippet to make some of my existing application to run in a remote Sql
server
> with the same structure (databases, views)...and I can't figure how...
> Anybody can help me?

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 local SQL server (For Developing)

I can't found my way to connect to local SQL server (On My Computer)

can any body help me

Ahmed Gaber

Perhaps these will help:

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

sql

how to connect domain SQLSERVER2005 to WORKGROUP SQLSERVER2005

hi

COMPUTER-1

IP ::::: 129.100.100.5

COMPUTER NAME IS ::::: HASH

MEMBER OF DOMAIN

in this computer sqlserver express edition is installed, i want to remove this express becoz in configuration manager it show two SQLSERVER'S are running. when i browse from COMPUTER - 2 for network servers it show server name as HASH/SQLEXPRESS, but not the main SQLSERVER.

COMPUTER -2

IP::::129.100.100.142

COMPUTER NAME::: FEROZ

MEMBER OF WORKGROUP

can anyone help me how to connect these two computers and remove this express edition

iam new to sqlserver configuration

thanks in advance

waiting for eager reply

To remove Express Edition, go to Control Panel/Add & Remove Programs/SQL Server 2005 - Change, and it will show you what is currently installed, and you will be able to chose to remove your Express instance.

As for how to 'connect these two computers', do you mean for database mirroring? It isn't clear from your post, and this is a database mirroring forum.

How to connect 2005 express

I installed SQL Server 2005 Express in a computer to replace MSDE.
Now I cannot connect it on my SQL Server Group with Server Enterprise
Manager.
Thanks
Did you enable remote access?
"M" <mxchen@.hotvoice.com> wrote in message
news:Onz7tSJDGHA.2036@.TK2MSFTNGP14.phx.gbl...
> I installed SQL Server 2005 Express in a computer to replace MSDE.
> Now I cannot connect it on my SQL Server Group with Server Enterprise
> Manager.
> Thanks
>
>
|||Enterprise manager can't mange SQL Server 2005 instances correctly. The
reason EM doesn't see it is probably because you haven't enabled and started
the sqlbrowser and enabled networking for your Express instance but even
when you can see it, EM won't be able to manage Express because it is not
forward compatible.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"M" <mxchen@.hotvoice.com> wrote in message
news:Onz7tSJDGHA.2036@.TK2MSFTNGP14.phx.gbl...
> I installed SQL Server 2005 Express in a computer to replace MSDE.
> Now I cannot connect it on my SQL Server Group with Server Enterprise
> Manager.
> Thanks
>
>
|||Yes. but The Server Enterprise Manager is 2000 version
"Martin" <mpennings@.wanadoo.nl> wrote in message
news:43b42163$0$208$dbd41001@.news.wanadoo.nl...
> Did you enable remote access?
> "M" <mxchen@.hotvoice.com> wrote in message
> news:Onz7tSJDGHA.2036@.TK2MSFTNGP14.phx.gbl...
>
>
|||It won't work, I just tried myself. Enterprise manager is not compatible.
You'll need another tool.
"M" <mxchen@.hotvoice.com> wrote in message
news:%23W7jz6LDGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Yes. but The Server Enterprise Manager is 2000 version
> "Martin" <mpennings@.wanadoo.nl> wrote in message
> news:43b42163$0$208$dbd41001@.news.wanadoo.nl...
>
>
|||It has been mentioned before, you can download it from:
http://www.microsoft.com/downloads/d...displaylang=en
"M" <mxchen@.hotvoice.com> wrote in message
news:%23W7jz6LDGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Yes. but The Server Enterprise Manager is 2000 version
> "Martin" <mpennings@.wanadoo.nl> wrote in message
> news:43b42163$0$208$dbd41001@.news.wanadoo.nl...
>
>
sql

How to configure SSAS 2005 for use with Excel

Using Excel I can connect to SSAS on localhost, but when I try to do the same from another computer, I can't connect to the server.

What can I configure to allow this connection ?

I already disactivated the firewall and I added a role to the cube that I want to use. But the connection error occures when listing the cube present on the server. I don't know what I can change now....

Thanks for your help.

hello,

Try downloading the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from the below link and try connecting it . It worked for me .

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Check the Content in Microsoft SQL Server 2000 PivotTable Services for details

regards

varadaraj

How to configure SSAS 2005 for use with Excel

Using Excel I can connect to SSAS on localhost, but when I try to do the same from another computer, I can't connect to the server.

What can I configure to allow this connection ?

I already disactivated the firewall and I added a role to the cube that I want to use. But the connection error occures when listing the cube present on the server. I don't know what I can change now....

Thanks for your help.

hello,

Try downloading the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from the below link and try connecting it . It worked for me .

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Check the Content in Microsoft SQL Server 2000 PivotTable Services for details

regards

varadaraj

How to configure Report Server in SQL Server 2005?

Hello, everyone:

I hope my question is clear.

I have SQl Server 2005 installed in local computer. I am planning to create report by Report Service so a report server is needed by which I can deploy report from my local computer to that server. How to intall the report server in another computer/

Thanks

ZYTZYT,
Your question is clear, but it doesn't look like you've done any research on the subject. There are plenty of KB articles and technical support documents regarding Reporting Services on the Microsoft website and numerous books exist on the subject.
If you encounter a specific problem when trying to implement Reporting Services having done the necessary research, people are more likely to help you, but they won't generally do all your work for you!

Lempster :S