Import or add Active Directory users into SQL2000 ?

Is there any way to import or add Active Directory users into a SQL2000
Database ?
Hi
You can query active directory through ADSI, but I think you would be better
off creating a windows group and add the users to that group as part of your
user creation process.
John
"tptools" wrote:

> Is there any way to import or add Active Directory users into a SQL2000
> Database ?

Import or add Active Directory users into SQL2000 ?

Is there any way possible to import or add Active Directory users into a
SQL2000 database ?
maybe Something like this would help u
EXEC sp_addlinkedserver
'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'
GO
go
sp_addlinkedSrvlogin 'ADSI',false, 'sa','USERNAME','PASSWORD'
go
select * from openquery(ADSI,'select GUID from
''LDAP://192.168.33.11:1003/o=e-enterprise/ou=members'' ')
"tptools" <tptools@.discussions.microsoft.com> wrote in message
news:4524D5FA-0115-4707-8674-9463C36E672C@.microsoft.com...
> Is there any way possible to import or add Active Directory users into a
> SQL2000 database ?

Import or add Active Directory users into SQL2000 ?

Is there any way possible to import or add Active Directory users into a
SQL2000 database ?maybe Something like this would help u
EXEC sp_addlinkedserver
'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'
GO
go
sp_addlinkedSrvlogin 'ADSI',false, 'sa','USERNAME','PASSWORD'
go
select * from openquery(ADSI,'select GUID from
''LDAP://192.168.33.11:1003/o=e-enterprise/ou=members'' ')
"tptools" <tptools@.discussions.microsoft.com> wrote in message
news:4524D5FA-0115-4707-8674-9463C36E672C@.microsoft.com...
> Is there any way possible to import or add Active Directory users into a
> SQL2000 database ?

Import or add Active Directory users into SQL2000 ?

Is there any way to import or add Active Directory users into a SQL2000
Database ?Hi
You can query active directory through ADSI, but I think you would be better
off creating a windows group and add the users to that group as part of your
user creation process.
John
"tptools" wrote:

> Is there any way to import or add Active Directory users into a SQL2000
> Database ?sql

Import or add Active Directory users into SQL2000 ?

Is there any way possible to import or add Active Directory users into a
SQL2000 database ?maybe Something like this would help u
EXEC sp_addlinkedserver
'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'
GO
go
sp_addlinkedSrvlogin 'ADSI',false, 'sa','USERNAME','PASSWORD'
go
select * from openquery(ADSI,'select GUID from
''LDAP://192.168.33.11:1003/o=e-enterprise/ou=members'' ')
"tptools" <tptools@.discussions.microsoft.com> wrote in message
news:4524D5FA-0115-4707-8674-9463C36E672C@.microsoft.com...
> Is there any way possible to import or add Active Directory users into a
> SQL2000 database ?

Import or add Active Directory users into SQL2000 ?

Is there any way to import or add Active Directory users into a SQL2000
Database ?Hi
You can query active directory through ADSI, but I think you would be better
off creating a windows group and add the users to that group as part of your
user creation process.
John
"tptools" wrote:
> Is there any way to import or add Active Directory users into a SQL2000
> Database ?

import MDF and LDF backup from SQL2000 to SQL2005

hi,

i have six files ( 3 MDF and 3 LDF) from a backup of a MS SQL 2000 server.

I installed MS SQL 2005 and wanted to Restore these Dataset. but they cant be accessed. doesnt SQL 2005 support these files ?

How can i use these files to access them with SQL 2005 ?

Thx,

Hello -

The files you're talking about are the "raw" data files that SQL Server uses, not a backup. When you take a backup from within SQL Server, files are acutally packaged a little differently, into a .bak file. When you use the BACKUP DATABASE command in SQL Server, it will create these files for you, which inlcude all of the "raw" files. You can then use the RESTORE DATABASE command to restore them to another (or the same) SQL Server.

All is not lost, however. If you have the MDF and LDF files, you can "adopt" these files directly into a running SQL Server system. That is called "attaching" a database. You can read more about that here:

http://msdn2.microsoft.com/en-us/library/ms190794.aspx

Buck Woody
http://www.buckwoody.com

import database from 7 to 2000 but SP and views not come

Hi All,
I am trying to import database from SQL7 to SQL2000 using the tool.
it looks normal but no SPs and Views and transfered and those not even in
the list when I run the transfer tool.
and idea?
TIA
Jerry Qu
Jerry,
You have to make sure you check those objects or they won't be transferred.
If you want the whole database try restoring a full backup. It's easier and
cleaner.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jerry Qu" <jqu@.capdex.com> wrote in message
news:OhQD9KpdEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I am trying to import database from SQL7 to SQL2000 using the tool.
> it looks normal but no SPs and Views and transfered and those not even in
> the list when I run the transfer tool.
> and idea?
>
> TIA
> Jerry Qu
>

import database from 7 to 2000 but SP and views not come

Hi All,
I am trying to import database from SQL7 to SQL2000 using the tool.
it looks normal but no SPs and Views and transfered and those not even in
the list when I run the transfer tool.
and idea?
TIA
Jerry QuJerry,
You have to make sure you check those objects or they won't be transferred.
If you want the whole database try restoring a full backup. It's easier and
cleaner.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jerry Qu" <jqu@.capdex.com> wrote in message
news:OhQD9KpdEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I am trying to import database from SQL7 to SQL2000 using the tool.
> it looks normal but no SPs and Views and transfered and those not even in
> the list when I run the transfer tool.
> and idea?
>
> TIA
> Jerry Qu
>

import database from 7 to 2000 but SP and views not come

Hi All,
I am trying to import database from SQL7 to SQL2000 using the tool.
it looks normal but no SPs and Views and transfered and those not even in
the list when I run the transfer tool.
and idea?
TIA
Jerry QuJerry,
You have to make sure you check those objects or they won't be transferred.
If you want the whole database try restoring a full backup. It's easier and
cleaner.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jerry Qu" <jqu@.capdex.com> wrote in message
news:OhQD9KpdEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I am trying to import database from SQL7 to SQL2000 using the tool.
> it looks normal but no SPs and Views and transfered and those not even in
> the list when I run the transfer tool.
> and idea?
>
> TIA
> Jerry Qu
>