One more connection problem-Security Issue

My company gave me their old Windows 2000 server. I installed my
database on it and the ODBC connection works perfectly on the server.
When I go to my client machine I go the the ODBC Connections in it and
it fails. It refuses connections and will not reply to pings. It is not
a network issue, as I can telnet to the server just fine. It's strictly
a security issue. I just have no clue where to look. Any suggestions
would be appreciated. ThanksCurt (myemail@.nowehere.com) writes:

Quote:

Originally Posted by

My company gave me their old Windows 2000 server. I installed my
database on it and the ODBC connection works perfectly on the server.
When I go to my client machine I go the the ODBC Connections in it and
it fails. It refuses connections and will not reply to pings. It is not
a network issue, as I can telnet to the server just fine. It's strictly
a security issue. I just have no clue where to look. Any suggestions
would be appreciated. Thanks

Which version of SQL Server?

If you are using SQL 2005, you need to enable remote connections, as by
default Express and Developer Editon only accepts local connections. You
can use the Surface Area Configuration tool for this.

Also, if you are using SQL Express, make sure that SQL Broswer is running,
so that the named instance can be found.

If you are using SQL 2000, I would look in the Server Network Utility
to see which protcols that are installed.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

OLEDB conn mgr change is not detected in BIDS/vs.net

I have changed the database name in an ole db connection manager. (The server name is identical)

When I run the package, it is still using the old db name.

I have tried restarting VS but it makes no difference.

How can I get it to stop caching the original name/update it to get the new name?restarting did fix the issue, but still it is ridiculous that you should have to take such an action

OLE DB Provider Oracle

english:

Hello,

I have got a problem with the a linked server in SQL server 2005 (64 bit) to Oracle 8.0.5. (32 bit).

Further details:

The old existing SQL server 2000 (32 bit) has a linked server to Oracle 8.0.5. The works with the OLE DB provider from Microsoft. The new SQL server 2005 (64 bit) should also have a linked server to this Oralce database. I have installed the Oracle 8.0 clients on the new server. The connection to oracle works with the client tools from Oracle.

But the SQL server 2005 couldn't connect to the oracle database.

The error message from the SQL server sounds (translated form a german error message):

A instance of the OLE DB provider "OraOLEDB.Oracle" for the linked server "xxxxxx" can't create.

Is the Oracle client software / OLE DB provider the problem?

Exist an other OLE DB provider for Oracle, may be from Microsoft, which works?

Thanks for your help

german:

Hallo Zusammen,

ích habe ein Problem bei der Migration von SQL Server 2005 auf ein x64 Windows System.

Problem ist folgendes:
Auf dem alten Server Windows x32 lief SQL Server 2000 mit einem Verbindungsserver zum Oracle Server 8.05. Das funktionierte mit dem OLE DB treiber von Microsoft hervoragend. Nun haben wir aber eine neue Windows x64 Maschine und ich m?chte die Verbindung zum Oracle Server wieder nutzen. Hatte die Oracle Client Software installiert und bekomme eine Fehlermeldung:

Eine Instanz des OLE DB Anbieters "ORAOLEDB.ORACLE" für den Verbindungsserver "xxxxx" kann nicht erstellt werden.

Ist das ein Problem mit der Oracle Client Software bzw. dem zugrunde liegenden OLE DB Treiber?
Gibt es einen anderen OLE DB Treiber für Oracle, z.B. von Microsoft, der funktionieren k?nnte?

Bin schon l?nger damit besch?ftigt, das zum Laufen zu bekommen. Die Oracle Version ist nicht die neueste, ich wei?.
Was kann ich tun, damit das endlich l?uft.

Für Hilfen w?re ich sehr dankbar.

If you are running 64-bit SQL, you need to use a 64-bit OLEDB provider with linked servers.

So you need to get Oracle's 64-bit OLEDB Provider for Oracle, Microsoft does not provide a 64-bit OLEDB Provider for Oracle.

|||

I got it mostly working with the latest oracle client (10.2.0.3) which you can download from Oracle if you have support with them. If you don't have the .3 version, you'll encounter a bug with their client if you make connections in DTS / intergration services packages to the Oracle DB server. I'm still running into an issue with a remote link server (see my other post).

Here are the steps I did to make the client work. Hope this helps you.

1) To get it working you need to do a custom installation and select at minimum:

Oracle Windows Interfaces (all)

Oracle Database Utilities

SQL*Plus

Oracle Net

2) You then need to copy the files: tnsnames.ora AND sqlnet.ora from another DB server to where ever the Oracle client is installed. In my case it's located at: D:\oracle\product\10.2.0\client\NETWORK\ADMIN

3) You then need to modify the registry to change the dll's that MDAC uses to connect to Oracle:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI

OracleXaLib=oraclient10.dll

OracleSqlLib=orasql10.dll

OracleOciLib=oci.dll

4) You then need to reboot to have the changes take effect.

5a) Browse to: /Server Objects/Linked Servers/Providers and right click on OraOLEDB.Oracle and select properties. Then check the following boxes: Dynamic parameter, Allow inprocess

5b) Then you need to create the link server in the Microsoft SQL Server Management Studio by doing the following:

Browse to: Server Objects/Linked Servers, right click and select "New Linked Server"

Enter the linked server name

Under provider select "Oracle Provider for OLE DB"

Enter a product name IE Oracle...

Enter the data source name (the same name in the tnsnames.ora file)

Select "Security" on the left side and select the last radio button "Be made using this security context" and enter the user name and password to connect to the remote db.

6) Then click OK :)

|||

Hello Arron,

thanks for the information.

I have installed the oracle version 10.2.0.1.0. That was the latest that I found on http://www.oracle.com/technology/software/products/database/oracle10g/index.html for Windows with 64-bit.

We haven't got a support contract with oracle, because it is an old version.

We wouldn't use DTS or integration services (would be nice if it's working also).
We need this only in stored procedures with SQL statements (SELECT, INSERT and UPDATE).

Stefan and MediaK

OLE DB Provider Oracle

english:

Hello,

I have got a problem with the a linked server in SQL server 2005 (64 bit) to Oracle 8.0.5. (32 bit).

Further details:

The old existing SQL server 2000 (32 bit) has a linked server to Oracle 8.0.5. The works with the OLE DB provider from Microsoft. The new SQL server 2005 (64 bit) should also have a linked server to this Oralce database. I have installed the Oracle 8.0 clients on the new server. The connection to oracle works with the client tools from Oracle.

But the SQL server 2005 couldn't connect to the oracle database.

The error message from the SQL server sounds (translated form a german error message):

A instance of the OLE DB provider "OraOLEDB.Oracle" for the linked server "xxxxxx" can't create.

Is the Oracle client software / OLE DB provider the problem?

Exist an other OLE DB provider for Oracle, may be from Microsoft, which works?

Thanks for your help

german:

Hallo Zusammen,

ích habe ein Problem bei der Migration von SQL Server 2005 auf ein x64 Windows System.

Problem ist folgendes:
Auf dem alten Server Windows x32 lief SQL Server 2000 mit einem Verbindungsserver zum Oracle Server 8.05. Das funktionierte mit dem OLE DB treiber von Microsoft hervoragend. Nun haben wir aber eine neue Windows x64 Maschine und ich m?chte die Verbindung zum Oracle Server wieder nutzen. Hatte die Oracle Client Software installiert und bekomme eine Fehlermeldung:

Eine Instanz des OLE DB Anbieters "ORAOLEDB.ORACLE" für den Verbindungsserver "xxxxx" kann nicht erstellt werden.

Ist das ein Problem mit der Oracle Client Software bzw. dem zugrunde liegenden OLE DB Treiber?
Gibt es einen anderen OLE DB Treiber für Oracle, z.B. von Microsoft, der funktionieren k?nnte?

Bin schon l?nger damit besch?ftigt, das zum Laufen zu bekommen. Die Oracle Version ist nicht die neueste, ich wei?.
Was kann ich tun, damit das endlich l?uft.

Für Hilfen w?re ich sehr dankbar.

If you are running 64-bit SQL, you need to use a 64-bit OLEDB provider with linked servers.

So you need to get Oracle's 64-bit OLEDB Provider for Oracle, Microsoft does not provide a 64-bit OLEDB Provider for Oracle.

|||

I got it mostly working with the latest oracle client (10.2.0.3) which you can download from Oracle if you have support with them. If you don't have the .3 version, you'll encounter a bug with their client if you make connections in DTS / intergration services packages to the Oracle DB server. I'm still running into an issue with a remote link server (see my other post).

Here are the steps I did to make the client work. Hope this helps you.

1) To get it working you need to do a custom installation and select at minimum:

Oracle Windows Interfaces (all)

Oracle Database Utilities

SQL*Plus

Oracle Net

2) You then need to copy the files: tnsnames.ora AND sqlnet.ora from another DB server to where ever the Oracle client is installed. In my case it's located at: D:\oracle\product\10.2.0\client\NETWORK\ADMIN

3) You then need to modify the registry to change the dll's that MDAC uses to connect to Oracle:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI

OracleXaLib=oraclient10.dll

OracleSqlLib=orasql10.dll

OracleOciLib=oci.dll

4) You then need to reboot to have the changes take effect.

5a) Browse to: /Server Objects/Linked Servers/Providers and right click on OraOLEDB.Oracle and select properties. Then check the following boxes: Dynamic parameter, Allow inprocess

5b) Then you need to create the link server in the Microsoft SQL Server Management Studio by doing the following:

Browse to: Server Objects/Linked Servers, right click and select "New Linked Server"

Enter the linked server name

Under provider select "Oracle Provider for OLE DB"

Enter a product name IE Oracle...

Enter the data source name (the same name in the tnsnames.ora file)

Select "Security" on the left side and select the last radio button "Be made using this security context" and enter the user name and password to connect to the remote db.

6) Then click OK :)

|||

Hello Arron,

thanks for the information.

I have installed the oracle version 10.2.0.1.0. That was the latest that I found on http://www.oracle.com/technology/software/products/database/oracle10g/index.html for Windows with 64-bit.

We haven't got a support contract with oracle, because it is an old version.

We wouldn't use DTS or integration services (would be nice if it's working also).
We need this only in stored procedures with SQL statements (SELECT, INSERT and UPDATE).

Stefan and MediaK

OLE DB provider MSDAORA was unable to begin a distributed transaction

Dear all,

I have been attempting to set up a linked server in SQL Server 2000 to point to an Oracle database (a very old Oracle database, v7!).

The linked server set up works fine. Then I created a database on the same SQL Server. Within that database I created a view which reads information from a view in the Oracle database (linked server). When I attempted to create this view in Enterprise Manager, I get the following error:

"The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction."

And so I created the view in Query Analyzer. This worked perfectly, no errors, and I can now go into Enterprise Manager and call up the view, which happily goes off to the view in the Oracle linked server and pulls back the info. BUT, when I attempt to do the same thing through an application on a different machine (using OLE Db, and a UDL to connect) the same error as above appears.

Does anyone know what this error means, and where I went wrong? Any help greatly appreciated. My view onto the linked server looks like this:

"CREATE VIEW dbo.NLPG_VIEW
AS
SELECT * from openquery(sadaslink, 'select * from NLPG_VIEW')"

Many thanks in advance for your wisdom!

P.S I wondered whether I need to check if the distributed transaction co-ordinator is running but don't know how.
Thanks,http://www.aspfaq.com/2455 fyi.|||Thanks, I've already had aread through this. I did create the view in query analyzer but the problem now is that I can't get it to work from a remote application. I think I need to look into the distributed transaction co-ordinator, but I don't know how or where. How do I see if it is running? How do I get it running?|||On the SQL Server, start the SQL Services Manager. Change the Service to Distributed Transaction Coordinator. Play to your heart's content!

FYI, with Oracle 7.3 I needed to use SET REMOTE_PROC_TRANSACTIONS (http://msdn.microsoft.com/library/en-us/tsqlref/ts_set-set_206r.asp) to make things happy.

-PatP|||Would SET_REMOTE_PROC_TRANSACTIONS have to be coded into the app, as I can't put it in the SQL in the view can I?|||http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx a guide to the solution.
Also check whether compatible Oracle driver is being used to connect, try with latest drivers.|||When you said remote procedure transactions, is that the same as setting remote procedure call in the GUI in enterprise manager? RPC and RPC OUT?

Thanks,
Paula|||No Polly, the concepts are related, but definitely not the same.

The problem is that SQL Server uses many flavors of locks in order to acheive true data consistancy... Some locks prohibit writing, some prohibit any access at all, and some do things that are difficult to describe in English, but make the engine behave as well as possible.

I haven't tried this in a long time, and no longer have an Oracle 7.x server to even test with, but I think you could get by with:SET REMOTE_PROC_TRANSACTIONS OFF
GO
CREATE VIEW dbo.NLPG_VIEW
AS
SELECT * from openquery(sadaslink, 'select * from NLPG_VIEW')All I can suggest that you do is to try it... I don't see how the attempt could hurt anything.

-PatP|||Thanks very much, I'll try it. Can't test it until next week, but Il'l let you know the results.

Old, deleted Identity values re-used?

If I have an Identity-declared column, the table has lots of rows and I start deleteting records - will any old, deleted identities be re-used (without an explicit re-seed) ?
(I'm talking about numerical Identities, not these GUID things)No. Not without manipulating the IDENTITY column. The exception being that if you TRUNCATE the table, then the seed will reset to the floor value.

Regards,

hmscott|||yeah,it can be used
need to set identity off
insert statement
reset identity on

Old version of SQL Server needed.

Does anyone know where I can get a 6.0 or older version of SQL Server?
Thanks in advance
Rob Valleehttp://www.emsps.com/oldtools/mssql.htm

old version of query analyzser for 2000

I have a SQL server 2000 systems that is likely going to be upgraded in the near future. However I need to look at the old data and system to recontruct the business cases that went in to the development. I'm trying to find an old copy of the query analyzer for SQL 2000 while I'm waiting for access to terminal services on the box. I've tried looking on Microsoft site but I'm unable to retrieve the download. Does anybody know where I can get a copy?

Hi,

You can use the Sql Management Express which works like a Query Analyzer + Enterprise Manager. It is for SQL2005 though you can still connect to SQL200 databases.

http://msdn.microsoft.com/vstudio/express/sql/

note: Find the download for SQL Server Management Studio Express

Or you can use a third party product like this:

http://www.sqlmanager.net/en/products/mssql/manager/download

cheers,

Paul June A. Domag

|||

Thanks,

Old Users / New Domain - Any way to directly update SYSXLOGINS

FIRST - I already know I it is not recommended to directly update systems
tables - no need to remind me. That being said, here is the scenario. I
have a bunch of users who are switching from one domain to another. EXAMPLE
login -
myco.us.east\joe should NOW be myco.us.west\joe
So, is there any easy way to just change the LOGIN name. I know that
SYSLOGINS is a view and that SYSXLOGINS is the root table. Problem is that
NAME in SYSXLOGINS doesnt seem to reflect the login name, rather the user
name. It would be great is I could just change the login name via SQL - Any
ideas on this' Exactly what columns and where?What is the version of SQL Server?
Take a look at sp_change_users_login in the BOL
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:CC69F7B5-2B63-4C12-AF93-D883BB692B28@.microsoft.com...
> FIRST - I already know I it is not recommended to directly update systems
> tables - no need to remind me. That being said, here is the scenario. I
> have a bunch of users who are switching from one domain to another.
> EXAMPLE
> login -
> myco.us.east\joe should NOW be myco.us.west\joe
> So, is there any easy way to just change the LOGIN name. I know that
> SYSLOGINS is a view and that SYSXLOGINS is the root table. Problem is
> that
> NAME in SYSXLOGINS doesnt seem to reflect the login name, rather the user
> name. It would be great is I could just change the login name via SQL -
> Any
> ideas on this' Exactly what columns and where?|||hi,
i feel it will not do what you want. Could you do it from EM ?
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"MSSQLServerDeveloper" wrote:

> FIRST - I already know I it is not recommended to directly update systems
> tables - no need to remind me. That being said, here is the scenario. I
> have a bunch of users who are switching from one domain to another. EXAMP
LE
> login -
> myco.us.east\joe should NOW be myco.us.west\joe
> So, is there any easy way to just change the LOGIN name. I know that
> SYSLOGINS is a view and that SYSXLOGINS is the root table. Problem is tha
t
> NAME in SYSXLOGINS doesnt seem to reflect the login name, rather the user
> name. It would be great is I could just change the login name via SQL - A
ny
> ideas on this' Exactly what columns and where?|||Hi,
FYI - The undocumented sysxlogins table doesn't exist in SQL 2005. The
syslogins view is preserved for backwards compatibility, but it's
deprecated.
Unfortunately, I think you will need to drop and recreate the logins.
I think it should be reasonably straightforward to generate the code to
do that. Since you have NT authenticated users, you won't have to
worry about passwords, which simplifies the task somewhat.
Good luck.
Regards,
Clifford Dibble [MSFT]
Andy Davis wrote:[vbcol=seagreen]
> hi,
> i feel it will not do what you want. Could you do it from EM ?
>
> Regards
> --
> Andy Davis
> Activecrypt Team
> ---
> SQL Server Encryption Software
> http://www.activecrypt.com
>
> "MSSQLServerDeveloper" wrote:
>

Old transaction log is reported as missing during recovery

I've done this at least 50 times without issue on various databases, but this
one just doesn't want to play nice.
So I have a SQLServer2K database setup. I've got a home-grown disaster
recovery process in place, so that transactions are taken from one server and
migrated to a backup server every hour. Once it's up and running, the
process is pretty flawless. However, getting it setup can be tricky.
1) Set the recovery model to "Full".
2) Backup your transaction logs
3) Do a full backup
4) Copy the backup to the backup server
5) Restore in to a read only database
Transaction logs can now be backed up on the source database, copied over
and applied to the backup server.
This isn't working this time though. No matter what I've tried, I still get
a message during the restore of the transaction logs such as the following:
"Executed as user: dbo. The log in this backup set begins at LSN
83111000001460600001, which is too late to apply to the database. An earlier
log backup that includes LSN 83075000002839600001 can be restored. [SQLSTATE
42000] (Error 4305) RESTORE LOG is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed."
Given the large gap between the two LSN #'s, I'm assuming that the database
thinks there is a very old transaction I'm missing. However, that is sheer
guesswork on my part.
The source box has been cycled, I've tried turning the recovery back and
forth between Full and Simple. This error is from my latest attempt, when I
swear I've done everything by the book.
Any suggestions of what might be causing this or where I should go from here?
Fred...
SQL lost a log somehow, I often had problems similar to this w/ home grown
log shipping.
Solution mostly relied upon: re-execute full backup, then restore & fire up
log shipping again. Full backup restores should be done nightly if
affordable...
Also - transactional replication ultimately proved the best solution for us,
transactions replicated within seconds, if we ever had to failover to backup,
I am much more confident minimal data would be lost as opposed to hourly log
restores...
Regards,
ChrisB
MCDBA OCP
www.MyDatabaseAdmin.com
"fkutz" wrote:

> I've done this at least 50 times without issue on various databases, but this
> one just doesn't want to play nice.
> So I have a SQLServer2K database setup. I've got a home-grown disaster
> recovery process in place, so that transactions are taken from one server and
> migrated to a backup server every hour. Once it's up and running, the
> process is pretty flawless. However, getting it setup can be tricky.
> 1) Set the recovery model to "Full".
> 2) Backup your transaction logs
> 3) Do a full backup
> 4) Copy the backup to the backup server
> 5) Restore in to a read only database
> Transaction logs can now be backed up on the source database, copied over
> and applied to the backup server.
> This isn't working this time though. No matter what I've tried, I still get
> a message during the restore of the transaction logs such as the following:
> "Executed as user: dbo. The log in this backup set begins at LSN
> 83111000001460600001, which is too late to apply to the database. An earlier
> log backup that includes LSN 83075000002839600001 can be restored. [SQLSTATE
> 42000] (Error 4305) RESTORE LOG is terminating abnormally. [SQLSTATE 42000]
> (Error 3013). The step failed."
> Given the large gap between the two LSN #'s, I'm assuming that the database
> thinks there is a very old transaction I'm missing. However, that is sheer
> guesswork on my part.
> The source box has been cycled, I've tried turning the recovery back and
> forth between Full and Simple. This error is from my latest attempt, when I
> swear I've done everything by the book.
> Any suggestions of what might be causing this or where I should go from here?
> Fred...

Old Subscriptions?

Hello, I have a server that lists several Subscriptions (under Replication ->
Subscriptions in Enterprise Manager) that are no longer in use. Two of them
reference a server that was decomissioned over a year ago which no longer
exists.
Why do these old subscriptions still show up in the Subscriptions list? Is
there a way to remove them? If so, how?
I would appreciate any feedback...
Thanks,
John
You can have a look at sp_MSenumsubscriptions to see what is happening when
you click on the subscriptions folder. The key tables in each subscribing
databases are sysmergesubscriptions and MSreplication_subscriptions. If this
database is no longer a subscriber, then run sp_removedbreplication, which
removes the redundant system tables. If you want these tables to remain,
then simply locate the redundant record in the above relevant system table
and delete it.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

old sql2k5 folder

I have remove the existing sql 2k5server db by "remove/add program" and the
install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
server folder and within. But it gives me an error saying it is in used ...
and therefore I cannot remove it. Can anyone please advise me how to remove
this folder? I thought the old folder is not used by any program after I
re-install a new ms sql server. Please help. Thanks.Hi,
have a look in the registry and search for the absolute path of the old
installation. There might be some logs which be flushed to the old
location.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Can anyone please help? Thanks
"00MichaelJordan" <MJ@.yahoo.com> wrote in message
news:ObrvrOfOHHA.4940@.TK2MSFTNGP03.phx.gbl...
>I have remove the existing sql 2k5server db by "remove/add program" and the
>install a new sql2k5 in another folder. Now I tried to remove the old MS
>SQL server folder and within. But it gives me an error saying it is in used
>... and therefore I cannot remove it. Can anyone please advise me how to
>remove this folder? I thought the old folder is not used by any program
>after I re-install a new ms sql server. Please help. Thanks.
>|||You need to see what process still has this folder open. When I'm
*desperate* I use this program:
http://ccollomb.free.fr/unlocker/
It will tell you what's using the file and will let you "force" it
closed, allowing you to delete it. Hopefully SQL Server will not be
using it. Try not to force-delete these things. See what program is
using the file first, shut it down, then delete the file. Just be
careful not to hose your SQL Server installation ;-)
-Dave Markle
http://www.markleconsulting.com/blog
00MichaelJordan wrote:
> I have remove the existing sql 2k5server db by "remove/add program" and th
e
> install a new sql2k5 in another folder. Now I tried to remove the old MS S
QL
> server folder and within. But it gives me an error saying it is in used ..
.
> and therefore I cannot remove it. Can anyone please advise me how to remo
ve
> this folder? I thought the old folder is not used by any program after I
> re-install a new ms sql server. Please help. Thanks.
>

old sql2k5 folder

I have remove the existing sql 2k5server db by "remove/add program" and the
install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
server folder and within. But it gives me an error saying it is in used ...
and therefore I cannot remove it. Can anyone please advise me how to remove
this folder? I thought the old folder is not used by any program after I
re-install a new ms sql server. Please help. Thanks.
Hi,
have a look in the registry and search for the absolute path of the old
installation. There might be some logs which be flushed to the old
location.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Can anyone please help? Thanks
"00MichaelJordan" <MJ@.yahoo.com> wrote in message
news:ObrvrOfOHHA.4940@.TK2MSFTNGP03.phx.gbl...
>I have remove the existing sql 2k5server db by "remove/add program" and the
>install a new sql2k5 in another folder. Now I tried to remove the old MS
>SQL server folder and within. But it gives me an error saying it is in used
>... and therefore I cannot remove it. Can anyone please advise me how to
>remove this folder? I thought the old folder is not used by any program
>after I re-install a new ms sql server. Please help. Thanks.
>
|||You need to see what process still has this folder open. When I'm
*desperate* I use this program:
http://ccollomb.free.fr/unlocker/
It will tell you what's using the file and will let you "force" it
closed, allowing you to delete it. Hopefully SQL Server will not be
using it. Try not to force-delete these things. See what program is
using the file first, shut it down, then delete the file. Just be
careful not to hose your SQL Server installation ;-)
-Dave Markle
http://www.markleconsulting.com/blog
00MichaelJordan wrote:
> I have remove the existing sql 2k5server db by "remove/add program" and the
> install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
> server folder and within. But it gives me an error saying it is in used ...
> and therefore I cannot remove it. Can anyone please advise me how to remove
> this folder? I thought the old folder is not used by any program after I
> re-install a new ms sql server. Please help. Thanks.
>

old sql2k5 folder

I have remove the existing sql 2k5server db by "remove/add program" and the
install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
server folder and within. But it gives me an error saying it is in used ...
and therefore I cannot remove it. Can anyone please advise me how to remove
this folder? I thought the old folder is not used by any program after I
re-install a new ms sql server. Please help. Thanks.Hi,
have a look in the registry and search for the absolute path of the old
installation. There might be some logs which be flushed to the old
location.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Can anyone please help? Thanks
"00MichaelJordan" <MJ@.yahoo.com> wrote in message
news:ObrvrOfOHHA.4940@.TK2MSFTNGP03.phx.gbl...
>I have remove the existing sql 2k5server db by "remove/add program" and the
>install a new sql2k5 in another folder. Now I tried to remove the old MS
>SQL server folder and within. But it gives me an error saying it is in used
>... and therefore I cannot remove it. Can anyone please advise me how to
>remove this folder? I thought the old folder is not used by any program
>after I re-install a new ms sql server. Please help. Thanks.
>|||You need to see what process still has this folder open. When I'm
*desperate* I use this program:
http://ccollomb.free.fr/unlocker/
It will tell you what's using the file and will let you "force" it
closed, allowing you to delete it. Hopefully SQL Server will not be
using it. Try not to force-delete these things. See what program is
using the file first, shut it down, then delete the file. Just be
careful not to hose your SQL Server installation ;-)
--
-Dave Markle
http://www.markleconsulting.com/blog
00MichaelJordan wrote:
> I have remove the existing sql 2k5server db by "remove/add program" and the
> install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
> server folder and within. But it gives me an error saying it is in used ...
> and therefore I cannot remove it. Can anyone please advise me how to remove
> this folder? I thought the old folder is not used by any program after I
> re-install a new ms sql server. Please help. Thanks.
>

Old Sql Server

Dear folks,
I can’t work out with that. I’m trying to add into my Enterprise Manager
(Sql2k) a sql Server 6.5 but appears this error:
Sql Server Registration failed because of the connection failure displayed
below: Do you wish to Register anyway?
[SQL- DMO] Sql Server SRVSMS2 must be upgraded to version 7.0 or later to be
administered by this version of sql-dmo
Any thought/solution in order to avoid upgrade that SQL to 7.0? I’ve been
tried it from Sql Server 7.0 and I obtain the same result.
Thanks in advance and regards,No. EM 7.0 can only connect to 7.0. EM 2000 can only connect to 2000 and 7.0
. None of those EM can
connect to 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:F7ABFAB7-81BB-49C0-9ECC-50585C4B048B@.microsoft.com...
> Dear folks,
> I can't work out with that. I'm trying to add into my Enterprise Manager
> (Sql2k) a sql Server 6.5 but appears this error:
> Sql Server Registration failed because of the connection failure displayed
> below: Do you wish to Register anyway?
> [SQL- DMO] Sql Server SRVSMS2 must be upgraded to version 7.0 or later to
be
> administered by this version of sql-dmo
> Any thought/solution in order to avoid upgrade that SQL to 7.0? I've been
> tried it from Sql Server 7.0 and I obtain the same result.
> Thanks in advance and regards,
>|||you are talking about I use ODBC or import data from Sql Server 6.5 to Acces
s
and from there to the recent versions?
Thanks for your input
"Tibor Karaszi" wrote:

> No. EM 7.0 can only connect to 7.0. EM 2000 can only connect to 2000 and 7
.0. None of those EM can
> connect to 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:F7ABFAB7-81BB-49C0-9ECC-50585C4B048B@.microsoft.com...
>
>|||I'm sorry but I don't understand your question. I simply replied saying that
the Enterprise Manager
that comes with 7.0 or 2000 cannot connect to a 6.5 server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:B1D2C92D-7479-41B0-B07A-073A78D01DBB@.microsoft.com...
> you are talking about I use ODBC or import data from Sql Server 6.5 to Acc
ess
> and from there to the recent versions?
> Thanks for your input
> "Tibor Karaszi" wrote:
>|||don't worry it's my fault. I've formulated a new question
"Tibor Karaszi" wrote:

> I'm sorry but I don't understand your question. I simply replied saying th
at the Enterprise Manager
> that comes with 7.0 or 2000 cannot connect to a 6.5 server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:B1D2C92D-7479-41B0-B07A-073A78D01DBB@.microsoft.com...
>
>

Old SQL ODBC driver on 2003 Server

Anyone run into this.
I have a Windows 2003 Server which has a very old sql Server ODBC Driver
installed. If I go into Data Sources and view the SQL Server driver it is
dated back in 1997. Very old and I suspect that when someone installed 6.5
SQL Server tools, it overwrote the newer driver.
Bottom line, how do I re-install SQL Server Driver, or other ODBC drivers
for that matter on a 2003 server without reinstalling the OS?
Eric Correa
Windows Server Engineer
Try installing the latest MDAC (version 2.8, I think). You can get that from the Microsoft site.
"Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
news:7ADBEB08-8E19-4B1A-B25D-95CFEA94C915@.microsoft.com...
> Anyone run into this.
> I have a Windows 2003 Server which has a very old sql Server ODBC Driver
> installed. If I go into Data Sources and view the SQL Server driver it is
> dated back in 1997. Very old and I suspect that when someone installed 6.5
> SQL Server tools, it overwrote the newer driver.
> Bottom line, how do I re-install SQL Server Driver, or other ODBC drivers
> for that matter on a 2003 server without reinstalling the OS?
> --
> Eric Correa
> Windows Server Engineer
|||You cannot install MDAC 2.8 on a Windows 2003 Server. Not allowed.
Eric Correa
Windows Server Engineer
"Scot T Brennecke" wrote:

> Try installing the latest MDAC (version 2.8, I think). You can get that from the Microsoft site.
> "Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
> news:7ADBEB08-8E19-4B1A-B25D-95CFEA94C915@.microsoft.com...
>
>
|||You will need to run an "update install" of Windows 2003 (or you could
re-install Windows 2003 SP1).
An "update install" is you just pop in the Windows 2003 CD and say you are
going to install it. The setup will prompt you if you want to do an "update
install" say yes. This is sort of like a repair install so to speak.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
news:745D9A13-B613-41A0-A949-63D9B712597F@.microsoft.com...[vbcol=seagreen]
> You cannot install MDAC 2.8 on a Windows 2003 Server. Not allowed.
> --
> Eric Correa
> Windows Server Engineer
>
> "Scot T Brennecke" wrote:

Old SQL ODBC driver on 2003 Server

Anyone run into this.
I have a Windows 2003 Server which has a very old sql Server ODBC Driver
installed. If I go into Data Sources and view the SQL Server driver it is
dated back in 1997. Very old and I suspect that when someone installed 6.5
SQL Server tools, it overwrote the newer driver.
Bottom line, how do I re-install SQL Server Driver, or other ODBC drivers
for that matter on a 2003 server without reinstalling the OS?
Eric Correa
Windows Server EngineerTry installing the latest MDAC (version 2.8, I think). You can get that fro
m the Microsoft site.
"Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
news:7ADBEB08-8E19-4B1A-B25D-95CFEA94C915@.microsoft.com...
> Anyone run into this.
> I have a Windows 2003 Server which has a very old sql Server ODBC Driver
> installed. If I go into Data Sources and view the SQL Server driver it is
> dated back in 1997. Very old and I suspect that when someone installed 6.5
> SQL Server tools, it overwrote the newer driver.
> Bottom line, how do I re-install SQL Server Driver, or other ODBC drivers
> for that matter on a 2003 server without reinstalling the OS?
> --
> Eric Correa
> Windows Server Engineer|||You cannot install MDAC 2.8 on a Windows 2003 Server. Not allowed.
--
Eric Correa
Windows Server Engineer
"Scot T Brennecke" wrote:

> Try installing the latest MDAC (version 2.8, I think). You can get that f
rom the Microsoft site.
> "Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
> news:7ADBEB08-8E19-4B1A-B25D-95CFEA94C915@.microsoft.com...
>
>|||You will need to run an "update install" of Windows 2003 (or you could
re-install Windows 2003 SP1).
An "update install" is you just pop in the Windows 2003 CD and say you are
going to install it. The setup will prompt you if you want to do an "update
install" say yes. This is sort of like a repair install so to speak.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
news:745D9A13-B613-41A0-A949-63D9B712597F@.microsoft.com...[vbcol=seagreen]
> You cannot install MDAC 2.8 on a Windows 2003 Server. Not allowed.
> --
> Eric Correa
> Windows Server Engineer
>
> "Scot T Brennecke" wrote:
>

Old SQL Design Tools

Hi Guys...

I was familiar to use sqlserver2000 more than 2 years, and Utilized from beneficial Tools Like Enterprise Manager and Query Analyzer which was so helpfull... .

afterthen I decide to get knowledge on SqlServer 2005 Enterpise Edition.

and after install 2CD's and SP1 , I try to find the Old Tools mentioned above , or find any DataBase as example , but I find nothing ... so is there any tool do the role to related tools in the last version , or should I get another vesion instead like Express or ...etc.

Thanks

Basel

There should be SQL Server Management Studio, which is both EM and QA at once (an many other features as well).

If only it's not an Express version, either.

|||

just a little word of inspiration

"Don't get intimidated by the new UI"

everything has changed. though you can find it out easily

|||

Inspiration is all what I need to start great new day

Tnax to send your helpful space

Old SQL Cluster to Join a New Domain?

Hi. In general terms, what would be the steps to have my
SQL2000 (on W2K OS) 2 node-clusters join a new domain?
They are member servers authenticating with a W2K DC on
their subnet, but we would like to install W2003 on that
DC (bare-metal NO upgrade, due to past history of AD
replication issues on that W2K DC. It's now the only DC
on it's own subnet, with very old AD info it. We figure
a clean install of W2003 with new clean domain would be
better).
Thanks.
Last time I did this, I just went into Windows, ignored the message that
popped up, and changed the domain name for each machine. (I stopped the
entire cluster first.)
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Look at the following article:
HOW TO: Change Domains for a SQL Server 2000 Failover Cluster
http://support.microsoft.com/?id=319016
Rand
This posting is provided "as is" with no warranties and confers no rights.

old question about login, but no help from the existing threads

osql -d adventureworks2000 -U admin -P admin
Login failed for user 'admin'. Reason: Not associated with a trusted SQL
Server connection.
My system and configurations:
- Winxp + sp2
- mssql developer edition + sp3a
- Windows Authentication only
- Local System Account is used to start the sql instance
- admin/admin is the administrator account to login to the xp box
- admin/admin was added to "SQL Server Group/[Machine Name]/Security/Log
ins"
with the database access and all database role assigned to the database in
question.
- admin/admin was added to "Databases/[database in question]/Users, with
Permit in Database Role all checked.
Am I missing anything?
Thanks> - Windows Authentication only
osql -d adventureworks2000 -E
AMB
"man-in-nature" wrote:

> osql -d adventureworks2000 -U admin -P admin
> Login failed for user 'admin'. Reason: Not associated with a trusted SQL
> Server connection.
> My system and configurations:
> - Winxp + sp2
> - mssql developer edition + sp3a
> - Windows Authentication only
> - Local System Account is used to start the sql instance
> - admin/admin is the administrator account to login to the xp box
> - admin/admin was added to "SQL Server Group/[Machine Name]/Security/L
ogins"
> with the database access and all database role assigned to the database in
> question.
> - admin/admin was added to "Databases/[database in question]/Users, wi
th
> Permit in Database Role all checked.
> Am I missing anything?
> Thanks
>