is it possible to install MSDE after SQL2000?

i installed MSDE _AFTER_ i installed sql2000. i finally got the install to work by specifying the instance name, but i can't connect to my msde instance via enterprise manager. i tried \mycomputer\vsdotnet (the instance name) but it says it's not there. any ideas?nevermind, the instance was netsdk, not vsdotnet.

Is it possible to have sqlcmd connect to local sqlexpress without a parameter?

(SQL Server Express 2005)

sqlcmd will connect to the local SQLExpress server just fine if I give the -S parameter:
SQLCMD -S .\SQLExpress

but is there any way to have it default to that so I can just say:
SQLCMD
?

Thanks,

dwh
You can do something like:
1) Create an Alias thorough Computer Management | SQL Server Configuration Manager | SQL Native Client Configuration
Alias Name: foo
Protocol: Named Pipes
Server: .\SQLExpress

2) Execute SQLCMD using the alias, like SQLCMD /S foo

Peter|||Umm... thanks, but that doesn't really help.

If I still need to say "sqlcmd /s foo", how is that any better than having to say "sqlcmd /s .\SQLExpress"?

Apparently on some machines here at work people are able to just say "sqlcmd" and it will default to the local SQL (Express) Server.

No?

Thanks,

dwh
|||They probably have a default instance installed. If /S is not specified, SQLCMD will try to connect to the dedfault instance. When installing Express, choose Advanced Options and then select "Default Instance". By default the Express setup installs Express and as a named instance called SQLEXPRESS.

To check whether they have a default or named istance, execute sp_helpserver against the server.

Peter

is it possible to connect to SQL Express without network?

I have notebook, client server application and sql express sp2 on this notebook.

Also, I know domain user login/password,

but I don't know any local user name/password

and I don't know any sql server user name/password.

Domain user is not a local administrator on this notebook.

When notebook connected to the office LAN I am working good with my app-> my sql express as a domain/user.

I'd like to work at home too. I can logon to the system (XP SP2) using domain account when notebook has no network connection. (probably OS caches something)

Is it possible to work with sql express using domain login when no network connection?

PS. old version of this software used MSDE 2000 and it was possible(!).

Thank you.

Yes. SQL Server will still work the same as when you are connected to the office LAN.

Since you log on with your domain credentials (they are cachd on the laptop), the same credentials are used to gain entry to SQL Server.

|||

Arnie Rowland wrote:

Yes. SQL Server will still work the same as when you are connected to the office LAN.

Since you log on with your domain credentials (they are cachd on the laptop), the same credentials are used to gain entry to SQL Server.

Ok, thank you.

I did experiment on 2 workstations.

On one machine ist working good, but on the second machine (no netowrk connection) when I tried to connect to the sql server I have a problem:

SSMS is ocnnecting ok

Application gives me message: cannot generate SSPI context.

What can it be? ...

Thank you

|||

Check these souces:

Error -Cannot generate SSPI context
http://support.microsoft.com/Default.aspx?id=811889
http://support.microsoft.com/kb/827422/en-us
http://support.microsoft.com/kb/843248/en-us
http://support.microsoft.com/kb/269541/en-us
http://support.microsoft.com/kb/267588/en-us
http://support.microsoft.com/kb/814401/en-us
http://support.microsoft.com/kb/818173/en-us

sql

Is it possible to connect to a SQL Server 2005 database usine asp.net v1.1

Hi,

I am having difficulties connecting to a SQL Server 2005 database from an ASP.NET windows application.

Is there any difference in the way the connection string is written when connecting to SQL Server 2005

I have the following connections in my App.config file :

<addkey="Sql2000ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2000DB; User ID=UID;Password=Pwd;"/>

<addkey="Sql2005ConnString"value="Data Source=xxx.xxx; Initial Catalog=Sql2005DB;User ID=UID; Password=Pwd;"/>

Every time I run my application it crashes when I try to connect to SQLServer2005 - The connection to the Sql2000 database works without any errors.

Do I need to write the connection differently??

Thanks

Hi kellem,

You would have to post your error message.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||Make sure the remote connections are enabled on the SQL2005 instance, which can be checked in Sql Server Surface Area Configuration.

Is it possible to connect a SQL server database to any NNTP server

Hi
This would mean re-writing the NNTP server application so that it stores and
retrieves the messages in the database rather than having an archive
facility?
You should therefore need to either look for a NNTP package that already
uses SQL Server (such as the one mentioned in this thread
http://tinyurl.com/dmeds) or write your own data access routines for an
existing package.
John
John
"J.S." wrote:

> I'd like to use a SQL server database as a backend for an NNTP server.
> Ideally, it would be the NNTP server that coems with Windows Server 2003 b
ut
> that is not essential.
> Is it possible to do this? What kind of application do I need to connect
> these two?
> Thanks,
> J.S.
> --
>
>Hi John,

> This would mean re-writing the NNTP server application so that it stores
> and
> retrieves the messages in the database rather than having an archive
> facility?
Yes, I think so. However, I am not sure which books I need to read or which
sections of MSDN I need to refer to for learning how to create such server
applications.

> You should therefore need to either look for a NNTP package that already
> uses SQL Server (such as the one mentioned in this thread
> http://tinyurl.com/dmeds) or write your own data access routines for an
> existing package.
I have been using Lyris ListManager for many years which already has this
functionality. However, I am just learning VS 2005 so I thought a good way
to learn would be to try to create such an application on my own.
Thanks,
J.S.

Is it possible to connect a SQL server database to any NNTP se

Hi
How to write a NNTP server in VC2005 is mainly a VC2005 issue so you may
want to post to a more appropriate group. There are many examples of using
VC++ and data access include in the SQL server examples and VC++ examples.
John
"J.S." wrote:

> Hi John,
>
> Yes, I think so. However, I am not sure which books I need to read or whi
ch
> sections of MSDN I need to refer to for learning how to create such server
> applications.
>
> I have been using Lyris ListManager for many years which already has this
> functionality. However, I am just learning VS 2005 so I thought a good wa
y
> to learn would be to try to create such an application on my own.
> Thanks,
> J.S.
>
>Thanks, John.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:B013D771-360D-4548-B2CD-D09A70651F94@.microsoft.com...
> Hi
> How to write a NNTP server in VC2005 is mainly a VC2005 issue so you may
> want to post to a more appropriate group. There are many examples of using
> VC++ and data access include in the SQL server examples and VC++ examples.
> John

Is it possible run C# .net Standard against SQL Server 2000?

Hi all!

I keep getting an error when I try and create a new data connection. This is the error I'm getting:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

I can connect to Access without any problems. Is there anyway around this?
I'm using C# .net Standard with SQL Server 2000.

Thanks for any help.>>It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

What version?? "C#.net standard" ??

What version of the .NET framework are you using? What IDE are you using?|||Thanks ehorn for reply

I'd like to runVisual C#.net 2003 Standard IDE against SQL Server 2000

I'm using Framework 1.1|||Given that you say this is the error:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.

I imagine that the problem is exactly what it says. That is, the version you are using will NOT allow you to access SQL Server. However, if you install the MSDE on your machine (which is binary compatible with SQL Server) you will be able to access that.|||Thanks Douglas for reply!

It was exactly what I did but now trying to install MSDE I'm getting the error:
'The instance name specified is invalid.'

Will I have to remove SQL Server first then try again?|||I expect so, or alternately, specify an instance name while installing MSDE.

Is it mandatory to install "SQL server client" to connect to server that has "SQL

Hello,

My database is on the server. I have a vb.net application installed on a client's machine. The problem is I am not able to connect to server from my application.

I have figured out that "SQL server client" is not installed on client's machine.

So is there any settings/utility available using which without installing SQL client I can connect to Server.

Any views/help would be apprecciated.

You do not need to install anything on the client to connect to RS. What error are you recieving?|||

The server machine contains the database and the vb.net application is installed on the client's machine. So my question is in order to connect to the database that resiedes on the server, should client's machine also need "sql server client" or is there any way in which the application can connect to database without "sql client" on client machine.

This has nothing to do with reporting services.

Thanks

|||

I would suggest posting your question here http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

This is a report server forum, so I assumed the question was about RS. Assuming you are using .Net, the answer would still be no, client tools are not required on the client for an application.

Is it mandatory to install "SQL server client" to connect to server that has "

Hello,

My database is on the server. I have a vb.net application installed on a client's machine. The problem is I am not able to connect to server from my application.

I have figured out that "SQL server client" is not installed on client's machine.

So is there any settings/utility available using which without installing SQL client I can connect to Server.

Any views/help would be apprecciated.

You do not need to install anything on the client to connect to RS. What error are you recieving?|||

The server machine contains the database and the vb.net application is installed on the client's machine. So my question is in order to connect to the database that resiedes on the server, should client's machine also need "sql server client" or is there any way in which the application can connect to database without "sql client" on client machine.

This has nothing to do with reporting services.

Thanks

|||

I would suggest posting your question here http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

This is a report server forum, so I assumed the question was about RS. Assuming you are using .Net, the answer would still be no, client tools are not required on the client for an application.

Is it any functions similar to "START WITH" and "CONNECT BY" in MS SQL?

Hi all,
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
Regards,
ThomasHello, Thomas
If you are interested in recursive queries for processing a tree-like
data structure, you should take a look at CTE-s (Common Table
Expressions) and Recursive CTE-s in Books Online and other MSDN
articles:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
Razvan|||Hi,
There is no equivalent of start with and connect by of oracle in sql
server,
got thorugh this links,
credit - vyaskn
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
Handling hierarchical data in Sql Server =>
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
Thanks,
Sree
Razvan Socol wrote:
> Hello, Thomas
> If you are interested in recursive queries for processing a tree-like
> data structure, you should take a look at CTE-s (Common Table
> Expressions) and Recursive CTE-s in Books Online and other MSDN
> articles:
> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
> http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
> Razvan|||> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
This information has not been updated for SQL 2005. Did you not follow the
links Razvan posted? It is certainly possible to accomplish this using
CTEs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<gsreejith@.gmail.com> wrote in message
news:1138965840.226876.87400@.g49g2000cwa.googlegroups.com...
> Hi,
> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
> credit - vyaskn
> http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
> Handling hierarchical data in Sql Server =>
> http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
> Thanks,
> Sree
>
> Razvan Socol wrote:
>> Hello, Thomas
>> If you are interested in recursive queries for processing a tree-like
>> data structure, you should take a look at CTE-s (Common Table
>> Expressions) and Recursive CTE-s in Books Online and other MSDN
>> articles:
>> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
>> http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
>> Razvan
>|||So, Should explicitly say for Sql Server 2000... :)
I have not tried CTE yet
Anyway thanks for correcting.
Thanks,
Sree

Is it any functions similar to "START WITH" and "CONNECT BY" in MS

Hi all,
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
Regards,
ThomasHello, Thomas
If you are interested in recursive queries for processing a tree-like
data structure, you should take a look at CTE-s (Common Table
Expressions) and Recursive CTE-s in Books Online and other MSDN
articles:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/msdnmag/i...TSQLinYukon/#S7
Razvan|||Hi,
There is no equivalent of start with and connect by of oracle in sql
server,
got thorugh this links,
credit - vyaskn
s.htm" target="_blank">http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
Handling hierarchical data in Sql Server =>
http://vyaskn.tripod.com/hierarchie...r_databases.htm
Thanks,
Sree
Razvan Socol wrote:
> Hello, Thomas
> If you are interested in recursive queries for processing a tree-like
> data structure, you should take a look at CTE-s (Common Table
> Expressions) and Recursive CTE-s in Books Online and other MSDN
> articles:
> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
> http://msdn.microsoft.com/msdnmag/i...TSQLinYukon/#S7
> Razvan|||> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
This information has not been updated for SQL 2005. Did you not follow the
links Razvan posted? It is certainly possible to accomplish this using
CTEs.
Hope this helps.
Dan Guzman
SQL Server MVP
<gsreejith@.gmail.com> wrote in message
news:1138965840.226876.87400@.g49g2000cwa.googlegroups.com...
> Hi,
> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
> credit - vyaskn
> s.htm" target="_blank">http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> Handling hierarchical data in Sql Server =>
> http://vyaskn.tripod.com/hierarchie...r_databases.htm
> Thanks,
> Sree
>
> Razvan Socol wrote:
>|||So, Should explicitly say for Sql Server 2000...
I have not tried CTE yet
Anyway thanks for correcting.
Thanks,
Sree