connect to local SQL2000 server from IDE

Can I connect to a local SQL2000 server from the IDE. I saw the "SQL Server Instance Name" option and tried to change it to both (local) and SQL2K, but it then tries to connect to ./SQL2K etc and fails.

I can only seem to

(1) connect to a named instance (./namedinstancename), which I do not use.

(2) be able to attach a new mdf, rather than connect to an existing db
I know that the express edition is restricted to local dbs, but is it also restricted to named instances?

ThanksCan you post the steps you used to find this. I can't seem to reproduce the problem.|||If the SQL2k instance is a default instance then you can connect just by using . or (local) or <<machinename>>. There is no need to tell SSMS that it is connecting to a SQL2k instance it will detect automatically.

If the instance is named then you need one of the above and then the instance name.

-Euan

Please reply only to the newsgroup/forum so that others can benefit. When posting,please state the version of SQL Server being used and the error number/exact error message text received, if any.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Can you kindly send the steps to create a db and table in sql2000?

connect to local SQL2000 server from IDE

Can I connect to a local SQL2000 server from the IDE. I saw the "SQL Server Instance Name" option and tried to change it to both (local) and SQL2K, but it then tries to connect to ./SQL2K etc and fails.

I can only seem to

(1) connect to a named instance (./namedinstancename), which I do not use.

(2) be able to attach a new mdf, rather than connect to an existing db
I know that the express edition is restricted to local dbs, but is it also restricted to named instances?

ThanksCan you post the steps you used to find this. I can't seem to reproduce the problem.|||If the SQL2k instance is a default instance then you can connect just by using . or (local) or <<machinename>>. There is no need to tell SSMS that it is connecting to a SQL2k instance it will detect automatically.

If the instance is named then you need one of the above and then the instance name.

-Euan

Please reply only to the newsgroup/forum so that others can benefit. When posting,please state the version of SQL Server being used and the error number/exact error message text received, if any.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Can you kindly send the steps to create a db and table in sql2000?sqlsql

Connect SQLRPS2005 to SQL2k DB?

How do I go about connecting SQLRPS2005 in SPS3.0 integration mode to
a SQL2k DB?
(Actually I want to report from a Project server 2003 instance, which
is based on sql2k.
I have SQLRPS2k5 installed on the sharepoint server and have lots of
green ticks for the installation. I have also installed the SPS3.0
plug-in and cofigured its paramters through SPS central.
Then I create a data source within my SPS report libary with:
Data source type: Microsoft SQL Server
connection string: data source=act01projsvr01;initial
catalog=ProjectServer
Credentials: windows integrated
However, when I try to create a report builder model using this data
source I get:
Cannot create a connection to data source 'EPM Pilot.rsds'.
(rsErrorOpeningConnection)
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
So obviously the current users windows credentials are not getting
passed through to the remote SQL server correctly?
Any ideas?It looks like double hop issue. Real (and hard) solution is to use Kerberos.
As workaround, you can try to use stored credentials instead of Windows
Integrated.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"scubaal" <al@.blakes.net> wrote in message
news:1173848679.463141.29360@.n59g2000hsh.googlegroups.com...
> How do I go about connecting SQLRPS2005 in SPS3.0 integration mode to
> a SQL2k DB?
> (Actually I want to report from a Project server 2003 instance, which
> is based on sql2k.
> I have SQLRPS2k5 installed on the sharepoint server and have lots of
> green ticks for the installation. I have also installed the SPS3.0
> plug-in and cofigured its paramters through SPS central.
> Then I create a data source within my SPS report libary with:
> Data source type: Microsoft SQL Server
> connection string: data source=act01projsvr01;initial
> catalog=ProjectServer
> Credentials: windows integrated
> However, when I try to create a report builder model using this data
> source I get:
> Cannot create a connection to data source 'EPM Pilot.rsds'.
> (rsErrorOpeningConnection)
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
> So obviously the current users windows credentials are not getting
> passed through to the remote SQL server correctly?
> Any ideas?
>