Can I install more then one copy of MSDE on a server?

We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
ClaytonOr can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Can both apps. share the same MSDE install?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
>
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||Yes, you can. It just requires a different instance name than the other
installed instances.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
Clayton|||You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||That depends on the app. The app may expect a particular instance name, for
example.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>> Or can I just use the same MSDE for the new app.? Can MSDE have more the
>> one DB?
>>
>> TIA,
>> Clayton
>>
>> "Clayton" <none@.none.com> wrote in message
>> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same
>> server. The new app. also needs MSDE. My question is can I install and
>> run more then one copy of MSDE? Is there anything I need to know about
>> doing it?
>>
>> TIA,
>> Clayton
>>
>

Can I get a Query from a Fetch_cursor in SQL2000

Hi, The main application we used uses prepared cursors when running statments against the database. This makes it very hard to debug the querys as if you get an error or lock on the database all you can see is the Fetch_curror statement and the number of the statment. If you know the lock is coming that's fine as you can run up the profiler but if you don't know it will happen then the profiler doesn't help as the cursor has already been prepared.

Is there a way of using the cursor number to query the SQL engine and find out what statment was prepared?

If your app is doing server side cursors and names them then you may be able to use sp_cursorlist, sp_describe_cursor_tables and sp_describe_cursor_columns to better understand what the query is doing. Then you can query the sysCacheObjects table in the master database and it will show you the first 128 characters of the batch (on 2005 it will show you the first 3900 characters) of cached plans. You can use the ObjType column to distinguish between ad-hoc, prepared, stored procedures etc.

See BOL for more info.

|||

Thanks fro the reply David but it still doesn't give me the query that was run (the TSQL), if all I had was the fetch_cursor id.

The sysCacheObjects is cool, I can use this for other things:)

|||True, you can't query the sysCacheObjects table just based on the cursor_id but I thought it would be the next best thing, since it gives you a place to look for cached plans and the queries that sparked them.|||

It is not possible to get the query with just the cursor handle in SQL Server 2000. You could query syscacheobjects if you know the prepare cursor call or a part of the SELECT statement etc. You will have to rely on SQL Profiler or application trace to get the calls.

In SQL Server 2005, you can use the new dynamic management function sys.dm_exec_cursors to better determine cursor handles on the server, their associated sql handles to get query text and other information.

sql

Can I do Regular Expressions using TSQL in SQL Server2005?

I am running PHP with SQL Server 2005. I have [bold] in some of the values in my result set, which needs to be striped out. I had a function in SQL Server2000 that did that, but the same function does not work in SQL Server2005. Any dieas?

CREATE FUNCTION

dbo.fn_regex(@.pattern varchar(255), @.matchstring varchar(8000))

RETURNS int

AS

BEGIN

declare @.obj int

declare @.res int

declare @.match bit

set @.match=0

exec @.res=sp_OACreate 'VBScript.RegExp',@.obj OUT

IF (@.res <> 0) BEGIN

RETURN NULL

END

exec @.res=sp_OASetProperty @.obj, 'Pattern', @.pattern

IF (@.res <> 0) BEGIN

RETURN NULL

END

exec @.res=sp_OASetProperty @.obj, 'IgnoreCase', 1

IF (@.res <> 0) BEGIN

RETURN NULL

END

exec @.res=sp_OAMethod @.obj, 'Test',@.match OUT, @.matchstring

IF (@.res <> 0) BEGIN

RETURN NULL

END

exec @.res=sp_OADestroy @.obj

return @.match

END

GO

When you say the functiuon doesn't work in SQL 2005; in what way doesn't it work? I see that you are using sp_OAxxx and friends; you are aware that you need to explicitly enable sp_OAxxx in S2K5, as a server setting?

Also, youwould be much, much, much better off using the CLR integration to do your stuff than sp_OA

Niels
|||Thanks for your response nielsb. Do you know if I can use CLR integration in a TSQL function. I am using PHP with SQL Server, so I do not have the option to use VB.net or C#?

Thanks!|||I don't fully understand the question? But, you can have s function written in C#, VB.NET, that's doing your stuff, and that function can be called by some T-SQL functions.

Niels
|||I cannot write the function in VB.NET or C#, as I am using PHP with SQL Server 2005 (which leave me the only option of write a TSQL function)|||Hmm, I still don't understand why you can not write a VB.NET or C# function. I.e. SQL Server 2005 hosts the CLR. You write a CLR function doing your regex stuff, this function is hosted by SQL Server and exposed by a T-SQL function. Your PHP code then calls the T-SQL function. Or am I totally off-track here?

Niels
|||Thanks for the response Niels! Do you think I can write a C# or VB.NET CLR function and call it within TSQL? Could you maybe give me an example of a CLR function. I have not used this before. your response is very much appreciated!

Can i developmy db in SQL Server MSDE then upload to SQL Server 20

I want to develop a web application using the MSDE version of SQL server -
will i then be able to upload it to a web host running SQL Server 2000?
Thanks
Yes.
"JoeConnor79" <JoeConnor79@.discussions.microsoft.com> wrote in message
news:8F42A758-7C69-4A04-94A7-5A7F1A0A709A@.microsoft.com...
> I want to develop a web application using the MSDE version of SQL server -
> will i then be able to upload it to a web host running SQL Server 2000?
> Thanks

Can I create and share snapshot folder on computer running IIS, but not computer running S

Hi all,
Usually , I will create a snapshot folder and share it on computer
running SQL Server for MR.
Now I have a question:
Can I create a snapshot folder on another computer which is running
IIS (For merge replication with SQL CE). The computer which is running
SQL Server was not installed IIS,just be installed SQL Server only.
Thanks,
The short answer is yes. Indeed, this would probably be considered the
"accepted" configuration -- one computer running IIS and one computer
running SQL Server. You are simply creating a virtual directory that your
publication is pointing toward to deposit the snapshot. However, your
publication must be able to access that virtual folder and if connectivity
is an issue then I would see you having problems. Note also that your SQLCE
server agent must be located in that virtual folder.
<pikctsach@.yahoo.com> wrote in message
news:55433649.0506201927.76979a0a@.posting.google.c om...
> Hi all,
> Usually , I will create a snapshot folder and share it on computer
> running SQL Server for MR.
> Now I have a question:
> Can I create a snapshot folder on another computer which is running
> IIS (For merge replication with SQL CE). The computer which is running
> SQL Server was not installed IIS,just be installed SQL Server only.
> Thanks,

Can I Clear SQL Event Log

Hi,
Is there a way to clear the SQL Server Event Log without
stopping/starting the SQL service? I am running SQL Server 2000. I am
not talking about the transaction logs.
Thank You.
DanHi Dan
I assume you are talking about the SQL Server error log. You cannot clear
the log, but you can start a new one, by using the procedure
sp_cycle_errorlog.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Dan" <moro0012@.yahoo.com> wrote in message
news:1136338503.760968.10520@.f14g2000cwb.googlegroups.com...
> Hi,
> Is there a way to clear the SQL Server Event Log without
> stopping/starting the SQL service? I am running SQL Server 2000. I am
> not talking about the transaction logs.
> Thank You.
> Dan
>

Can I change the SQL 2000 Cluster database from case-sensitive to case-insensitive in the

Hi All,
I'd like to know if I can change the SQL 2000 Cluster database configuration
from case-sensitive to case-insensitive in the running box. If yes, how can
I do that?
TIACould you please send more detail and/or one example of what you are trying
to accomplish?
Ben Nevarez, MCDBA, OCP
Database Administrator
"M C" wrote:
> Hi All,
> I'd like to know if I can change the SQL 2000 Cluster database configuration
> from case-sensitive to case-insensitive in the running box. If yes, how can
> I do that?
> TIA
>
>|||Hi ALL,
When I first installed SQL 2000 Cluster, I choose the case-sensitive when
the setup prompt for collation. I'm now want to change the collation to
case-insensitive. Can I do that?
TIA.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:404BF5E3-E8E0-420A-9193-6E41C93B2DE3@.microsoft.com...
> Could you please send more detail and/or one example of what you are
> trying
> to accomplish?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "M C" wrote:
>> Hi All,
>> I'd like to know if I can change the SQL 2000 Cluster database
>> configuration
>> from case-sensitive to case-insensitive in the running box. If yes, how
>> can
>> I do that?
>> TIA
>>|||"M C" <abc@.def.com> wrote in message
news:umNMiyomGHA.3732@.TK2MSFTNGP05.phx.gbl...
> Hi ALL,
> When I first installed SQL 2000 Cluster, I choose the case-sensitive when
> the setup prompt for collation. I'm now want to change the collation to
> case-insensitive. Can I do that?
Not on a server-wide basis w/o doing a complete re-install.
On a per database basis you can, but it can get messy.
> TIA.
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:404BF5E3-E8E0-420A-9193-6E41C93B2DE3@.microsoft.com...
> >
> > Could you please send more detail and/or one example of what you are
> > trying
> > to accomplish?
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "M C" wrote:
> >
> >> Hi All,
> >>
> >> I'd like to know if I can change the SQL 2000 Cluster database
> >> configuration
> >> from case-sensitive to case-insensitive in the running box. If yes, how
> >> can
> >> I do that?
> >>
> >> TIA
> >>
> >>
> >>
>sql

Can I change a datasource's properties at report execution time?

I will be running reports on a shared database server. The database server
supports one main application with many environments for different user
groups. Each groupsâ' data is kept in a different database instance.
I want to deploy my reports in a single location on the shared database
server to simplify installing reporting services and deploying reports.
When a user requests a on-demand report I want the report to pull the data
from the correct SQL Server instance.
Can I to change the reportâ's shared datasource â'Connection Stringâ' to the
userâ's database instance. I will be using SOAP to invoke the reports.
Are there other ways to accomplish my intentions?
I am using SQL Server 2000 Reporting Services Developer Edition with SP1 and
SQL Server 2000 Standard Edition with service packs 1, 2, 3, and 3a applied.Hi,
You may want to use 'SetReportDataSources' to switch between datasources.
More information about this method can be found from the MSDN site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_soapapi_intro_0dnq.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Can I change a datasource's properties at report execution
time?
>thread-index: AcUz8ztCgxbpG2rJQdCyH/tlSmdIXw==>X-WBNR-Posting-Host: 192.85.47.1
>From: =?Utf-8?B?dGV4YXMzNDYw?= <texas3460@.noemail.nospam>
>Subject: Can I change a datasource's properties at report execution time?
>Date: Mon, 28 Mar 2005 16:07:01 -0800
>Lines: 17
>Message-ID: <26693252-7562-4848-9FD1-9D529F3D40F9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46323
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>I will be running reports on a shared database server. The database
server
>supports one main application with many environments for different user
>groups. Each groupsâ' data is kept in a different database instance.
>I want to deploy my reports in a single location on the shared database
>server to simplify installing reporting services and deploying reports.
>When a user requests a on-demand report I want the report to pull the data
>from the correct SQL Server instance.
>Can I to change the reportâ's shared datasource â'Connection Stringâ'
to the
>userâ's database instance. I will be using SOAP to invoke the reports.
>Are there other ways to accomplish my intentions?
>I am using SQL Server 2000 Reporting Services Developer Edition with SP1
and
>SQL Server 2000 Standard Edition with service packs 1, 2, 3, and 3a
applied.
>

Can I access my private db through my web server?

Web server: win2003 server with iis6
DB: sql server 2000

I have 50+ remote offices running an Access 2002 app which connects
directly to sql server at a 3rd party hosting company, in part using an
odbc connection on the workstation.

We recently moved our database (and our web site) in-house. The new
database is inside the firewall but outside the dmz, where it lives
along side the company's most sensitive databases. IT's policy won't
allow us to connect directly from the internet. I'm trying to avoid
buying another copy of sql server for the Access app, which I one day
hope to drop anyway in favor of

The web server uses port 1433 to talk to the database. I was wondering
if there is a simple way to route requests from the Access app through
the web server.

Thanks,
Bob(bcanavan@.bmghomes.com) writes:
> Web server: win2003 server with iis6
> DB: sql server 2000
> I have 50+ remote offices running an Access 2002 app which connects
> directly to sql server at a 3rd party hosting company, in part using an
> odbc connection on the workstation.
> We recently moved our database (and our web site) in-house. The new
> database is inside the firewall but outside the dmz, where it lives
> along side the company's most sensitive databases. IT's policy won't
> allow us to connect directly from the internet. I'm trying to avoid
> buying another copy of sql server for the Access app, which I one day
> hope to drop anyway in favor of
> The web server uses port 1433 to talk to the database. I was wondering
> if there is a simple way to route requests from the Access app through
> the web server.

Have you considered setting up a VPN?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, Erland.

VPN is a good suggestion, but my second paragraph above was cut off and
should have read:

"I'm trying to avoid buying another copy of sql server for the Access
app, which I one day hope to drop anyway in favor of a pure web app."

If I can do that by the end of the year I'll have saved us all many
hours of unnecessary work since just about everything is begin
converted for web access, and VPN won't be necessary. (In my case my
remote offices are sales offices who don't collaborate with each other
on documents, spread sheets, etc.)

So, if I could just address a connection from the Access app -->
through the web server --> to the database (and for read-only requests
at that!) I would be very happy.

Bob|||(bcanavan@.bmghomes.com) writes:
> VPN is a good suggestion, but my second paragraph above was cut off and
> should have read:
> "I'm trying to avoid buying another copy of sql server for the Access
> app, which I one day hope to drop anyway in favor of a pure web app."
> If I can do that by the end of the year I'll have saved us all many
> hours of unnecessary work since just about everything is begin
> converted for web access, and VPN won't be necessary. (In my case my
> remote offices are sales offices who don't collaborate with each other
> on documents, spread sheets, etc.)
> So, if I could just address a connection from the Access app -->
> through the web server --> to the database (and for read-only requests
> at that!) I would be very happy.

I will have to admit that networking is not my speciality, but what you
describes sounds very much like VPN to me.

That is, with VPN you would have to buy another SQL Server for the Access
people; they could connect directly to SQL Server once they have their
VPN up.

Route it through the web server? Of course, you could have a proxy that...
But I don't think you admin folks would like that.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Like I said...if we used vpn we wouldn't have to buy/install another
copy of sql server. Users could log in through Active Directory.

I'm trying to avoid the time and expense of setting up vpn in 50
offices when it's likely to be replaced by a web app by December.

Bob|||(bcanavan@.bmghomes.com) writes:
> Like I said...if we used vpn we wouldn't have to buy/install another
> copy of sql server. Users could log in through Active Directory.

I'm not sure that I get this. In your previous post you seemed to
be anxious that VPN would require another server. Now you are saying
that it does not.

> I'm trying to avoid the time and expense of setting up vpn in 50
> offices when it's likely to be replaced by a web app by December.

VPN is the only that I can think of that is secure. It's possible that
you could set up a proxy through a web page (this is definitely not
the group what you can do in a web server), but it certainly sounds
dangerous to me. After all, then you are exposing SQL Server on the
Internet - which you admin folks don't like.

Since setting up VPN on the connecting side is a simple task, I'm not
really sure that I see the problem.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, Erland.

The point of my post was that VPN is a good suggestion, but doesn't
look feasible at the moment. VPN would not require a new file server,
or a new copy of sql server, because users would have direct access to
the existing sql server database as though they were on the LAN. The
problem is that setting up VPN in our remote offices is not completely
compatible with our IT department's goals or policies. (I'm a
developer, not a member of the IT team.) The possibility of installing
a new server (located inside the dmz) was mentioned above only as the
painful alternative to having no other way to connect directly to our
sql server database (as a source of readOnly data) through the
internet, barring the rewriting of the Access app to use other
technologies such as xml.

Here's the thing...my application is in transition between Access and
my web app, and I need to buy some time. The only part of the Access
app that needs access to the db right now are the reports. (The data
itself is now entered and edited online through my web app.) Later
this fall the reports will be integrated into the web app, and I'll be
able to scrap Access altogether. At that point I'll be discarding any
work I do to supply data to these Access reports during the transition,
so I want to keep it to a minimum and spend most of my time building
permanent things.

As far as security goes, users already have to log in to the web app
through Integrated Windows Authentication(IIS6) + Active Directory +
SSL, and they have read/write permissions. From there, access to sql
server is based on trusted accounts, and is carefully monitored by
myself and IT. So, I reason that I would have at least that much
security going for me if I could pump readOnly data back to the
logged-in Access app in the remote offices using the web server.

I'm looking for a solution (that doesn't breach anyone's security
policies) such as:

Using the web server as a proxy through an odbc connection.

Or possibly opening a connection through .NET on the web server.

Here's another idea...from the remote Access app...can I link to sql
pass-through SELECT queries in an Access mdb on the web server?

I'm just trying to use my head(and yours) before I invest in something
that will be thrown away soon. It hurts when I see someone spend
thousand$ to solve problems like this with "obvious" solutions, and
then find something some creative geek did that would have saved a lot
of time and money. It's even better when users and IT don't even know
something changed, and wouldn't care anyway! Work is more fun when
you're really as clever as you like people to think you are.

Thanks for your interest.

Bob|||(bcanavan@.bmghomes.com) writes:
> The problem is that setting up VPN in our remote offices is not
> completely compatible with our IT department's goals or policies.

OK. If your IT department does not like VPN, they do ot like VPN.

> Here's another idea...from the remote Access app...can I link to sql
> pass-through SELECT queries in an Access mdb on the web server?

Don't ask me. I don't know Access, I don't know web servers.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, Erland.

I didn't mean to burden you with it personally. I thought I was in a
forum.

Thanks for your interest, though.

Bob|||(bcanavan@.bmghomes.com) writes:
> I didn't mean to burden you with it personally. I thought I was in a
> forum.

Yeah, you are. :-) But since I've been about the only person answering
you, I only wanted to make it clear that I have nothing to add.

And there was kind of a hint: try a forum where they know IIS and/or
Access.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Can default and named instance co-exist?

I have 2 Windows 2003 servers running SQL2000. They each have separate
databases. I am in the process of clustering these 2 machines together. I
have purchased a shared external SCSI PowerVault appliance to put the quorom
and the shared databases on. I want to create a Virtual SQL server using
these 2 machines and put their separate databases on the virtual server. My
question is:
Do I have to uninstall SQL server on each machine before I install the
virtual server? If I have to I would have to restore my databases to the new
virtual server
Or can I just install a new named instance of SQL server - choosing the
virtual server in the setup? If I can do this - it would be a lot easier
moving my databases over to the new server.
If I can just create a new virtual server with leaving the original SQL in
tact - will the original still be available to my users if I decide not to
move all the databases over that day?
Is there one way that is better than the other?
1. If you want to use the exact same instance names, uninstall/reinstall for
clustering is needed. If not, you can just virtualize your new instance and
migrate data.
2. Consider reading through this kb for some details
http://support.microsoft.com/kb/224071
3. Your original instance will continue to run while you're installing a new
instance on the same node.
The bottom line, I would create a new instance and ensure it's up and
running before tinkering with the original.
-oj
"Amy Lewis" <AmyLewis@.discussions.microsoft.com> wrote in message
news:223F3934-2F36-4A2D-B5D5-D860055AE5E7@.microsoft.com...
>I have 2 Windows 2003 servers running SQL2000. They each have separate
> databases. I am in the process of clustering these 2 machines together.
> I
> have purchased a shared external SCSI PowerVault appliance to put the
> quorom
> and the shared databases on. I want to create a Virtual SQL server using
> these 2 machines and put their separate databases on the virtual server.
> My
> question is:
> Do I have to uninstall SQL server on each machine before I install the
> virtual server? If I have to I would have to restore my databases to the
> new
> virtual server
> Or can I just install a new named instance of SQL server - choosing the
> virtual server in the setup? If I can do this - it would be a lot easier
> moving my databases over to the new server.
> If I can just create a new virtual server with leaving the original SQL in
> tact - will the original still be available to my users if I decide not to
> move all the databases over that day?
> Is there one way that is better than the other?
|||Each instance of SQL Server requires its own shared disk. You can install
either 1 default instance and 15 named instances or up to 16 named
instances, but each must have its own shared drive. All drives must have a
drive letter, no mount points allowed. For existing nonclustered instances,
if you move the data files to a shared drive then you will have the option
during setup to upgrade the standalone instance to a virtual/clustered
instance (assuming you're using the Enterprise Edition setup).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

can dbcc inputbuffer show parameterized queries?

Hi,
I'm trying to capture blocking information on my SQL Server 2k box and
running dbcc inputbuffer only shows me the "sp_executesql" command, it
doesn't show me the parameters which is the actual sql. Profiler seems to
have no problem showing the parameters b/c it always shows me the sql that's
running, not the sp_executesql command. Is there some other command that
will pull the sql from a parameterized query a la Profiler? Thanks for any
help here.
lcLC,
Have you tried using fn_get_sql()? (Although for sp_executesql I usually
get nothing unless a stored procedure is being executed.)
RLF
"LC" <LC@.discussions.microsoft.com> wrote in message
news:013B24CA-D81B-48AA-9D7C-56ABA375A30D@.microsoft.com...
> Hi,
> I'm trying to capture blocking information on my SQL Server 2k box and
> running dbcc inputbuffer only shows me the "sp_executesql" command, it
> doesn't show me the parameters which is the actual sql. Profiler seems to
> have no problem showing the parameters b/c it always shows me the sql
> that's
> running, not the sp_executesql command. Is there some other command that
> will pull the sql from a parameterized query a la Profiler? Thanks for
> any
> help here.
> lc|||I've tried that function, but all of the sql handles in my databases are
0x000000... Since all of the sql handles are the same (all zero's), I'm not
getting any useful information.
"Russell Fields" wrote:
> LC,
> Have you tried using fn_get_sql()? (Although for sp_executesql I usually
> get nothing unless a stored procedure is being executed.)
> RLF
> "LC" <LC@.discussions.microsoft.com> wrote in message
> news:013B24CA-D81B-48AA-9D7C-56ABA375A30D@.microsoft.com...
> > Hi,
> > I'm trying to capture blocking information on my SQL Server 2k box and
> > running dbcc inputbuffer only shows me the "sp_executesql" command, it
> > doesn't show me the parameters which is the actual sql. Profiler seems to
> > have no problem showing the parameters b/c it always shows me the sql
> > that's
> > running, not the sp_executesql command. Is there some other command that
> > will pull the sql from a parameterized query a la Profiler? Thanks for
> > any
> > help here.
> >
> > lc
>
>|||LC
Dbcc inputbuffer shows the last command to execute through the connection.
Fn_get_sql only can work for a statement that is running _right_now_, since
as soon as a statement is complete the handle returns to 0. Therefore, most
of your sql handles should be zero, but not is a stored procedure is
actually running at the moment.
FWIW - RLF
"LC" <LC@.discussions.microsoft.com> wrote in message
news:6D105C91-1A27-413A-8117-6619CDDE76C4@.microsoft.com...
> I've tried that function, but all of the sql handles in my databases are
> 0x000000... Since all of the sql handles are the same (all zero's), I'm
> not
> getting any useful information.
> "Russell Fields" wrote:
>> LC,
>> Have you tried using fn_get_sql()? (Although for sp_executesql I usually
>> get nothing unless a stored procedure is being executed.)
>> RLF
>> "LC" <LC@.discussions.microsoft.com> wrote in message
>> news:013B24CA-D81B-48AA-9D7C-56ABA375A30D@.microsoft.com...
>> > Hi,
>> > I'm trying to capture blocking information on my SQL Server 2k box and
>> > running dbcc inputbuffer only shows me the "sp_executesql" command, it
>> > doesn't show me the parameters which is the actual sql. Profiler seems
>> > to
>> > have no problem showing the parameters b/c it always shows me the sql
>> > that's
>> > running, not the sp_executesql command. Is there some other command
>> > that
>> > will pull the sql from a parameterized query a la Profiler? Thanks for
>> > any
>> > help here.
>> >
>> > lc
>>
>>

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?
More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:

> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alias
> for the IP number and that works but an alias for the machine name does not.
> With a DHCP server, the IP address isn't permanent so how do I configure the
> connection in my application?

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:

> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alia
s
> for the IP number and that works but an alias for the machine name does no
t.
> With a DHCP server, the IP address isn't permanent so how do I configure t
he
> connection in my application?

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:
> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alias
> for the IP number and that works but an alias for the machine name does not.
> With a DHCP server, the IP address isn't permanent so how do I configure the
> connection in my application?

Can connect to sql 7 but not sql 2000

I have three boxes: a web server running windows 2003, a database server
running windows 2000 and sql server 7 and another database server running
windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
replacement for the sql 7 box. The web server is in the DMZ while the
database servers are in our internal network.
The web server can get through our firewall to the sql 7 box with no issues.
However, when we try connecting from the web server to the sql 2000 box, we
keep getting 'Error establishing socket. Connection Refused' messages.
The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
also reviewed the TCP/IP settings suggested in other posts but have still
come up with nothing. Have I overlooked something else?
Check the "Server Network Configuration" to find out whether "TCP-IP"
protocol has been added.
"Mike Smith" wrote:

> I have three boxes: a web server running windows 2003, a database server
> running windows 2000 and sql server 7 and another database server running
> windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
> replacement for the sql 7 box. The web server is in the DMZ while the
> database servers are in our internal network.
> The web server can get through our firewall to the sql 7 box with no issues.
> However, when we try connecting from the web server to the sql 2000 box, we
> keep getting 'Error establishing socket. Connection Refused' messages.
> The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
> also reviewed the TCP/IP settings suggested in other posts but have still
> come up with nothing. Have I overlooked something else?
|||TCP-IP is the only protocol enabled.
"Jason Lu" wrote:
[vbcol=seagreen]
> Check the "Server Network Configuration" to find out whether "TCP-IP"
> protocol has been added.
> "Mike Smith" wrote:

Can connect to sql 7 but not sql 2000

I have three boxes: a web server running windows 2003, a database server
running Windows 2000 and sql server 7 and another database server running
windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
replacement for the sql 7 box. The web server is in the DMZ while the
database servers are in our internal network.
The web server can get through our firewall to the sql 7 box with no issues.
However, when we try connecting from the web server to the sql 2000 box, we
keep getting 'Error establishing socket. Connection Refused' messages.
The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
also reviewed the TCP/IP settings suggested in other posts but have still
come up with nothing. Have I overlooked something else?Check the "Server Network Configuration" to find out whether "TCP-IP"
protocol has been added.
"Mike Smith" wrote:

> I have three boxes: a web server running windows 2003, a database server
> running Windows 2000 and sql server 7 and another database server running
> windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
> replacement for the sql 7 box. The web server is in the DMZ while the
> database servers are in our internal network.
> The web server can get through our firewall to the sql 7 box with no issue
s.
> However, when we try connecting from the web server to the sql 2000 box, w
e
> keep getting 'Error establishing socket. Connection Refused' messages.
> The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
> also reviewed the TCP/IP settings suggested in other posts but have still
> come up with nothing. Have I overlooked something else?|||TCP-IP is the only protocol enabled.
"Jason Lu" wrote:
[vbcol=seagreen]
> Check the "Server Network Configuration" to find out whether "TCP-IP"
> protocol has been added.
> "Mike Smith" wrote:
>

Can connect to sql 7 but not sql 2000

I have three boxes: a web server running windows 2003, a database server
running windows 2000 and sql server 7 and another database server running
windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
replacement for the sql 7 box. The web server is in the DMZ while the
database servers are in our internal network.
The web server can get through our firewall to the sql 7 box with no issues.
However, when we try connecting from the web server to the sql 2000 box, we
keep getting 'Error establishing socket. Connection Refused' messages.
The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
also reviewed the TCP/IP settings suggested in other posts but have still
come up with nothing. Have I overlooked something else?Check the "Server Network Configuration" to find out whether "TCP-IP"
protocol has been added.
"Mike Smith" wrote:
> I have three boxes: a web server running windows 2003, a database server
> running windows 2000 and sql server 7 and another database server running
> windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
> replacement for the sql 7 box. The web server is in the DMZ while the
> database servers are in our internal network.
> The web server can get through our firewall to the sql 7 box with no issues.
> However, when we try connecting from the web server to the sql 2000 box, we
> keep getting 'Error establishing socket. Connection Refused' messages.
> The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
> also reviewed the TCP/IP settings suggested in other posts but have still
> come up with nothing. Have I overlooked something else?|||TCP-IP is the only protocol enabled.
"Jason Lu" wrote:
> Check the "Server Network Configuration" to find out whether "TCP-IP"
> protocol has been added.
> "Mike Smith" wrote:
> > I have three boxes: a web server running windows 2003, a database server
> > running windows 2000 and sql server 7 and another database server running
> > windows 2003 and sql server 2000 (with sp4). The sql 2000 box is a
> > replacement for the sql 7 box. The web server is in the DMZ while the
> > database servers are in our internal network.
> >
> > The web server can get through our firewall to the sql 7 box with no issues.
> > However, when we try connecting from the web server to the sql 2000 box, we
> > keep getting 'Error establishing socket. Connection Refused' messages.
> >
> > The firewall rules for the sql 7 and sql 2000 boxes are the same. I have
> > also reviewed the TCP/IP settings suggested in other posts but have still
> > come up with nothing. Have I overlooked something else?

Can connect from Query Analyzer but not from Report Services

I can terminal service into the box running Reporting Services. If I try to
run the
report I can't connect, it says login failed. Using the same
username/password which is sa because it's a log shipped server. I can
connect through Query Analizer. The only rememdy is to restart both servers.
Then I can connect. Then it will go hey wire after a day or two and same
situation. What could be causing this?
Please help me,
BryanAlso if I try to do net stop reportserver it says the server is not
responding to the control function. Actually the same thing happens if I try
to shut down the secondary log shipped server that the reports are pointing
at. If I do net stop mssqlserver. It gives me the same error. Something is
going on here between the two and I can't figure out what it is that is going
on?
"bmurtha" wrote:
> I can terminal service into the box running Reporting Services. If I try to
> run the
> report I can't connect, it says login failed. Using the same
> username/password which is sa because it's a log shipped server. I can
> connect through Query Analizer. The only rememdy is to restart both servers.
> Then I can connect. Then it will go hey wire after a day or two and same
> situation. What could be causing this?
> Please help me,
> Bryan

Can coexist express server 2005 with sql 7 in the same machine?

I have SQL server 7 installed and running ok. Can I install express server? The idea is to have two different databases for different applications, each running in each sql.In short yes, but only one can be the default instance, Express will need to be a named instance

Can anyone offer me any suggestions on how to create a back up site w/ db in the

I am currently running a site on a shared environment with sql db. The account is with verio.com: Windows Server 2003m SQL 2000.

What we would like to do is create a back up site with a backup db. I would like this functionality so that in the event of a crash, while the current site is being repaired, or if the server is down for a prolonged period, I can simply switch to the backup site w/ db.

What would the preferable method of doing this in such an environment? Any help would be greatly appreciated. Thanks.Look into Log Shipping, sounds like it may answer your needs.|||I just read up on that at:

http://www.sql-server-performance.com/sql_server_log_shipping.asp

Very interesting...however can I pull that off in a shared environment, even if I have to get a second account?|||I don't see any issue with LS working in shared environment.
Can you explain about second account?|||Originally posted by rdjabarov
Look into Log Shipping, sounds like it may answer your needs.