HI,
I have attempted to connect a user to a SQL 2000 server, running on a
Windows 2000 server using Windows Authentication and always get the
follwoing error message:
Connection failed
SQLstate:'28000'
sql server error: 18456
[microsoft][odbc sql server driver][sql server] login
failed for user "Domain\user1"
Can anyone explain to me why this is happening? I've looked at the
SQL Server Agent Properties and on the Connection tab it specifies use
Windows Authentication, but yet I can't get any Domain user to connect
to the server?!
Thanks,
Art
Hi,
You have to give that domain user to authenticate to SQL Server.
1. Login to SQL Server using Query analyzer with a user with sysadmin role
2. Execute the below commmands:-
sp_grantlogin '[domainname\Groupname]'
eg:
EXEC sp_grantlogin '[Finance\RPTGROUP]'
Command to give access previlage to the user to database.
sp_grantdbaccess '[domainname\Groupname]','user_name_in_database'
Eg:
use dbname
go
EXEC sp_grantdbaccess '[Finance\RPTGROUP]','RPTGROUP'
After this login to domain user and tr to create the system DSN.
Thanks
Hari
MCDBA
"Art Billings" <abillings@.principle-tech.com> wrote in message
news:8c11e0tjdn66knipdut4te4vnb92e8gbtj@.4ax.com...
> HI,
> I have attempted to connect a user to a SQL 2000 server, running on a
> Windows 2000 server using Windows Authentication and always get the
> follwoing error message:
> Connection failed
> SQLstate:'28000'
> sql server error: 18456
> [microsoft][odbc sql server driver][sql server] login
> failed for user "Domain\user1"
> Can anyone explain to me why this is happening? I've looked at the
> SQL Server Agent Properties and on the Connection tab it specifies use
> Windows Authentication, but yet I can't get any Domain user to connect
> to the server?!
> Thanks,
> Art
|||Thanks for the response to my query. Didn't expect one, so that was a
pleasant surprise. We worked it out, turns out that the Domain Users
group had not been given expicit access to any of the databases. Once
we configured that, then allowed them public access and execute rights
on the stored procedure we were developing, everything worked as smooth
as silk. Imagine that!!
Thanks again!
Art
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Showing posts with label connect. Show all posts
Showing posts with label connect. Show all posts
Tuesday, February 14, 2012
Can't use system DSN to log user on
HI,
I have attempted to connect a user to a SQL 2000 server, running on a
Windows 2000 server using Windows Authentication and always get the
follwoing error message:
Connection failed
SQLstate:'28000'
sql server error: 18456
[microsoft][odbc sql server driver][sql server] login
failed for user "Domain\user1"
Can anyone explain to me why this is happening? I've looked at the
SQL Server Agent Properties and on the Connection tab it specifies use
Windows Authentication, but yet I can't get any Domain user to connect
to the server'!
Thanks,
ArtHi,
You have to give that domain user to authenticate to SQL Server.
1. Login to SQL Server using Query analyzer with a user with sysadmin role
2. Execute the below commmands:-
sp_grantlogin '[domainname\Groupname]'
eg:
EXEC sp_grantlogin '[Finance\RPTGROUP]'
Command to give access previlage to the user to database.
sp_grantdbaccess '& #91;domainname\Groupname]','user_name_in
_database'
Eg:
use dbname
go
EXEC sp_grantdbaccess '[Finance\RPTGROUP]','RPTGROUP'
After this login to domain user and tr to create the system DSN.
Thanks
Hari
MCDBA
"Art Billings" <abillings@.principle-tech.com> wrote in message
news:8c11e0tjdn66knipdut4te4vnb92e8gbtj@.
4ax.com...
> HI,
> I have attempted to connect a user to a SQL 2000 server, running on a
> Windows 2000 server using Windows Authentication and always get the
> follwoing error message:
> Connection failed
> SQLstate:'28000'
> sql server error: 18456
> [microsoft][odbc sql server driver][sql server] login
> failed for user "Domain\user1"
> Can anyone explain to me why this is happening? I've looked at the
> SQL Server Agent Properties and on the Connection tab it specifies use
> Windows Authentication, but yet I can't get any Domain user to connect
> to the server'!
> Thanks,
> Art|||Thanks for the response to my query. Didn't expect one, so that was a
pleasant surprise. We worked it out, turns out that the Domain Users
group had not been given expicit access to any of the databases. Once
we configured that, then allowed them public access and execute rights
on the stored procedure we were developing, everything worked as smooth
as silk. Imagine that!!
Thanks again!
Art
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
I have attempted to connect a user to a SQL 2000 server, running on a
Windows 2000 server using Windows Authentication and always get the
follwoing error message:
Connection failed
SQLstate:'28000'
sql server error: 18456
[microsoft][odbc sql server driver][sql server] login
failed for user "Domain\user1"
Can anyone explain to me why this is happening? I've looked at the
SQL Server Agent Properties and on the Connection tab it specifies use
Windows Authentication, but yet I can't get any Domain user to connect
to the server'!
Thanks,
ArtHi,
You have to give that domain user to authenticate to SQL Server.
1. Login to SQL Server using Query analyzer with a user with sysadmin role
2. Execute the below commmands:-
sp_grantlogin '[domainname\Groupname]'
eg:
EXEC sp_grantlogin '[Finance\RPTGROUP]'
Command to give access previlage to the user to database.
sp_grantdbaccess '& #91;domainname\Groupname]','user_name_in
_database'
Eg:
use dbname
go
EXEC sp_grantdbaccess '[Finance\RPTGROUP]','RPTGROUP'
After this login to domain user and tr to create the system DSN.
Thanks
Hari
MCDBA
"Art Billings" <abillings@.principle-tech.com> wrote in message
news:8c11e0tjdn66knipdut4te4vnb92e8gbtj@.
4ax.com...
> HI,
> I have attempted to connect a user to a SQL 2000 server, running on a
> Windows 2000 server using Windows Authentication and always get the
> follwoing error message:
> Connection failed
> SQLstate:'28000'
> sql server error: 18456
> [microsoft][odbc sql server driver][sql server] login
> failed for user "Domain\user1"
> Can anyone explain to me why this is happening? I've looked at the
> SQL Server Agent Properties and on the Connection tab it specifies use
> Windows Authentication, but yet I can't get any Domain user to connect
> to the server'!
> Thanks,
> Art|||Thanks for the response to my query. Didn't expect one, so that was a
pleasant surprise. We worked it out, turns out that the Domain Users
group had not been given expicit access to any of the databases. Once
we configured that, then allowed them public access and execute rights
on the stored procedure we were developing, everything worked as smooth
as silk. Imagine that!!
Thanks again!
Art
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Sunday, February 12, 2012
Can't update table using mysql
Hello.
I use VS2005 and I was trying to make a little program able to connect to a MySQL 5.0.18 database through MyODBC 3.51.12. I can connect to the database and I can load a table in the Datagridview control, but I can't update the table: the wizard didn't generate the Update method. Even if I configure again the tableAdapter, the wizard generates only:
SELECT statement
table mappings
Fill method
Get method
The table is a very simple table: it has 3 columns and the first is a primary key.
I use VS2005 and I was trying to make a little program able to connect to a MySQL 5.0.18 database through MyODBC 3.51.12. I can connect to the database and I can load a table in the Datagridview control, but I can't update the table: the wizard didn't generate the Update method. Even if I configure again the tableAdapter, the wizard generates only:
SELECT statement
table mappings
Fill method
Get method
The table is a very simple table: it has 3 columns and the first is a primary key.
If I create an identical table using Access database and make a program that connects through ODBC, I don't have the problem: the wizard generates also the UPDATE, INSERT and DELETE statements.
Where is the difference? What is the problem?
Thankyou so much for the help
Anthony R.
The MyODBC Driver could not generate the UPDATE command. But the MySQLDirect .NET Data Provider for example generates without problems.
Can anybody help?
|||I am having a huckuva time trying to get this to work as well. If someone else has any ideas, I would love to hear it.
However, I am working on a project that may work. I do not know if I can get to it soon, so I thought I would post the idea to see if someone else tried it -- to see if I am barking up the wrong tree.
I am using VS2005, MySQL 5, and MyODBC 3.51
I am viewing a TableAdapter in the DataSet Designer. I right-click on the TableAdapter and select Properties. Within the properties are the InsertCommand, DeleteCommand, and UpdateCopmmand methods. They are blank, of course, because as we have noticed, they can't automatically generate.
However, by expanding one of the commands (UpdateCommand, for example) we have access to the CommandText, where we can define the MySQL Command needed to update the table. We also have access to the Parameters, where we define the parameters we will pass.
If I get the chance, I will attempt to try this. If anyone else beats me to it, please let me know if it works.
|||Someone in the Visual Basic General forum may be able to provide some insights as to why these particular drivers are not generating UPDATE commands.
To follow up on mking's theory, there is some good basic info on the TableAdapter class at: http://msdn2.microsoft.com/en-us/library/bz9tthwx.aspx with lots of good links (including http://msdn2.microsoft.com/en-us/library/dex7k4dw.aspx, which walks through the TableAdapter Configuration Wizard). This information should hopefully provide you with enough information to follow up on MKing's idea and generate the appropriate UPDATE statements.
For additional help with the TableAdapter Configuration Wizard, I'd recommend the Visual Basic General forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=32&SiteID=1. The ADO.NET forum might also be able to provide some assistance: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=45&SiteID=1.
Good luck,
Jason
|||Jason,Thanks for the tips. However, after some intense drinking, I figured it out. Then I wrote a tutorial about it, which everyone can find on VBMySQl.com.
Friday, February 10, 2012
Can''t understand how to connect SQL SERVER EXPRESS 2005
I can't understand how I configure SQLServerExpress2005 in my computer. I use Visual Studio 2005. How I connect the database from it? I can't configure SQL. Please help me..
Do you just want to scroll through the objects within the database or do you want to make a call to the database from your code ? Is the database server attached oder a user instance ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||to connect to Database from Application change the connection string. Refer
http://www.connectionstrings.com/?carrier=sqlserver2005
If you have installed SQLServer Management Studio Express you can connection to database. This is the tool comes with the express to do all the managemnt works in SQL Server
Madhu
Can''t understand how to connect SQL SERVER EXPRESS 2005
I can't understand how I configure SQLServerExpress2005 in my computer. I use Visual Studio 2005. How I connect the database from it? I can't configure SQL. Please help me..
Do you just want to scroll through the objects within the database or do you want to make a call to the database from your code ? Is the database server attached oder a user instance ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||to connect to Database from Application change the connection string. Refer
http://www.connectionstrings.com/?carrier=sqlserver2005
If you have installed SQLServer Management Studio Express you can connection to database. This is the tool comes with the express to do all the managemnt works in SQL Server
Madhu
Can''t understand how to connect SQL SERVER EXPRESS 2005
I can't understand how I configure SQLServerExpress2005 in my computer. I use Visual Studio 2005. How I connect the database from it? I can't configure SQL. Please help me..
Do you just want to scroll through the objects within the database or do you want to make a call to the database from your code ? Is the database server attached oder a user instance ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||to connect to Database from Application change the connection string. Refer
http://www.connectionstrings.com/?carrier=sqlserver2005
If you have installed SQLServer Management Studio Express you can connection to database. This is the tool comes with the express to do all the managemnt works in SQL Server
Madhu
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
ead/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnu
m=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> hread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&r
num=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the ro
ad
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>|||Script them out in encrypted form and use that same encrypted for when creat
ing them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp
_help_revlogin (search
for that word) has something you can use in order to facilitate the scriptin
g of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords sin
ce
> they are encrypted? Thanks.
> "ChrisR" wrote:
>
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
ead/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnu
m=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> hread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&r
num=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the ro
ad
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>|||Script them out in encrypted form and use that same encrypted for when creat
ing them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp
_help_revlogin (search
for that word) has something you can use in order to facilitate the scriptin
g of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords sin
ce
> they are encrypted? Thanks.
> "ChrisR" wrote:
>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/...9a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
New SQL Server DBA
New SQL Server DBA
I would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/...9a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA
|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>
|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/...9a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
New SQL Server DBA
New SQL Server DBA
I would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/...9a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA
|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>
|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
Subscribe to:
Posts (Atom)