TITLE: Microsoft SQL Server Management Studio
Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued
and failed.
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued
and failed.
And evenlog message
The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor
of the client library. [CLIENT: <local machine>]
I am using Sql Server 2005 Developer Edition 9.0.1399.
I have searched around but cannot find.
Thank you for your help.
ZaferHi Zafer,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you create a
Maintenance plan in SQL Server Management Studio, you get the following
error:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued and failed.
If I misunderstood your concern, please feel free to point it out.
Please verify that your server has a valid cert stored in
computer->personal.
On the SQL Server computer, create a Microsoft Management Console (MMC)
snap-in for the Certificates tool. To do this, follow these steps:
a. Click "Start", click "Run", type "mmc" (without the quotation marks)
in the
"Open" box, and then click "OK".
b. On the "File" menu, click "Add/Remove Snap-in".
c. Click "Add", click "Certificates", click "Add", click "Computer
account",
click "Next", click "Finish", click "Close", and then click "OK".
Also, you may check your SQL Server Service Account. If you run SQL Server
as local system, is this issue occur?
Hope this will be helpful!
Sincerely yours,
Wei Lu
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.
Showing posts with label additional. Show all posts
Showing posts with label additional. Show all posts
Monday, March 19, 2012
I try to create a maintenance plan I am getting the error
TITLE: Microsoft SQL Server Management Studio
Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued
and failed.
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued
and failed.
And evenlog message
The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor
of the client library. [CLIENT: <local machine>]
I am using Sql Server 2005 Developer Edition 9.0.1399.
I have searched around but cannot find.
Thank you for your help.
Zafer
Hi Zafer,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you create a
Maintenance plan in SQL Server Management Studio, you get the following
error:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued and failed.
If I misunderstood your concern, please feel free to point it out.
Please verify that your server has a valid cert stored in
computer->personal.
On the SQL Server computer, create a Microsoft Management Console (MMC)
snap-in for the Certificates tool. To do this, follow these steps:
a. Click "Start", click "Run", type "mmc" (without the quotation marks)
in the
"Open" box, and then click "OK".
b. On the "File" menu, click "Add/Remove Snap-in".
c. Click "Add", click "Certificates", click "Add", click "Computer
account",
click "Next", click "Finish", click "Close", and then click "OK".
Also, you may check your SQL Server Service Account. If you run SQL Server
as local system, is this issue occur?
Hope this will be helpful!
Sincerely yours,
Wei Lu
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.
Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued
and failed.
An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued
and failed.
And evenlog message
The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor
of the client library. [CLIENT: <local machine>]
I am using Sql Server 2005 Developer Edition 9.0.1399.
I have searched around but cannot find.
Thank you for your help.
Zafer
Hi Zafer,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you create a
Maintenance plan in SQL Server Management Studio, you get the following
error:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued and failed.
If I misunderstood your concern, please feel free to point it out.
Please verify that your server has a valid cert stored in
computer->personal.
On the SQL Server computer, create a Microsoft Management Console (MMC)
snap-in for the Certificates tool. To do this, follow these steps:
a. Click "Start", click "Run", type "mmc" (without the quotation marks)
in the
"Open" box, and then click "OK".
b. On the "File" menu, click "Add/Remove Snap-in".
c. Click "Add", click "Certificates", click "Add", click "Computer
account",
click "Next", click "Finish", click "Close", and then click "OK".
Also, you may check your SQL Server Service Account. If you run SQL Server
as local system, is this issue occur?
Hope this will be helpful!
Sincerely yours,
Wei Lu
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.
Labels:
additional,
create,
database,
error,
informationan,
invocation,
maintenance,
management,
microsoft,
mscorlib,
mysql,
ole,
oracle,
plan,
server,
sql,
studioexception,
target,
thrown
I try to create a maintenance plan I am getting the error
TITLE: Microsoft SQL Server Management Studio
Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued
and failed.
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued
and failed.
And evenlog message
The prelogin packet used to open the connection is structurally invalid; the
connection has been closed. Please contact the vendor
of the client library. [CLIENT: <local machine>]
I am using Sql Server 2005 Developer Edition 9.0.1399.
I have searched around but cannot find.
Thank you for your help.
ZaferHi Zafer,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you create a
Maintenance plan in SQL Server Management Studio, you get the following
error:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued and failed.
If I misunderstood your concern, please feel free to point it out.
Please verify that your server has a valid cert stored in
computer->personal.
On the SQL Server computer, create a Microsoft Management Console (MMC)
snap-in for the Certificates tool. To do this, follow these steps:
a. Click "Start", click "Run", type "mmc" (without the quotation marks)
in the
"Open" box, and then click "OK".
b. On the "File" menu, click "Add/Remove Snap-in".
c. Click "Add", click "Certificates", click "Add", click "Computer
account",
click "Next", click "Finish", click "Close", and then click "OK".
Also, you may check your SQL Server Service Account. If you run SQL Server
as local system, is this issue occur?
Hope this will be helpful!
Sincerely yours,
Wei Lu
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.
Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued
and failed.
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued
and failed.
And evenlog message
The prelogin packet used to open the connection is structurally invalid; the
connection has been closed. Please contact the vendor
of the client library. [CLIENT: <local machine>]
I am using Sql Server 2005 Developer Edition 9.0.1399.
I have searched around but cannot find.
Thank you for your help.
ZaferHi Zafer,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you create a
Maintenance plan in SQL Server Management Studio, you get the following
error:
An OLE DB error 0x80004005 (Client unable to establish connection) occurred
while enumerating packages. A SQL statement was issued and failed.
If I misunderstood your concern, please feel free to point it out.
Please verify that your server has a valid cert stored in
computer->personal.
On the SQL Server computer, create a Microsoft Management Console (MMC)
snap-in for the Certificates tool. To do this, follow these steps:
a. Click "Start", click "Run", type "mmc" (without the quotation marks)
in the
"Open" box, and then click "OK".
b. On the "File" menu, click "Add/Remove Snap-in".
c. Click "Add", click "Certificates", click "Add", click "Computer
account",
click "Next", click "Finish", click "Close", and then click "OK".
Also, you may check your SQL Server Service Account. If you run SQL Server
as local system, is this issue occur?
Hope this will be helpful!
Sincerely yours,
Wei Lu
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.
Labels:
additional,
create,
database,
error,
informationan,
invocation,
maintenance,
management,
microsoft,
mscorlib,
mysql,
ole,
oracle,
plan,
server,
sql,
studioexception,
target,
thrown
Friday, March 9, 2012
I need to set up a ADDITIONAL server with unique userid/password. How?
I already have a SQL Server defined. I want to do some testing using a
different userid/password for the server. Reason: I am emulating another
site for testing purposes. Since the userid/password seems to be at the
Server level, and not a database level, it looks like I need to define
another server with a different userid/password combo. Is this right or am
I missing the boat?
(Yes, I need SQL Server security. I can't get by with Windows-only)
TIA,
Larry WoodsLogins are at the server level.
Users are at the database level.
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||> Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo.
You can create the desired login using a script like the one below.
EXEC sp_addlogin 'MyLogin', 'MyPassword'
USE MyDatabase
EXEC sp_adduser 'MyLogin'
--if role-based security
EXEC sp_addrolemember 'MyRole', 'MyLogin'
Hope this helps.
Dan Guzman
SQL Server MVP
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||O.K. Here is my situation. The ONLY SQL Server that I have defined was
defined with Windows-only security; therefore no SQL Server security. Now,
I need a SQL Server defined that has both Windows and SQL Server security.
That's why I "think" that I need to define a second server.
Make sense?
TIA,
Larry Woods
"Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> Logins are at the server level.
> Users are at the database level.
>
> "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
another
> am
>|||You can switch down from Windows only to Mixed Mode for your current server,
create an SQL Server login and do testings for that login, as you wish. Just
make sure you consider security in doing that, and make sure that you set a
password for sa before switching down. :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:e14MnO7%23DHA.2860@.tk2msftngp13.phx.gbl...
> O.K. Here is my situation. The ONLY SQL Server that I have defined was
> defined with Windows-only security; therefore no SQL Server security.
Now,
> I need a SQL Server defined that has both Windows and SQL Server security.
> That's why I "think" that I need to define a second server.
> Make sense?
> TIA,
> Larry Woods
> "Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
> news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
a
> another
the
define
or
>
different userid/password for the server. Reason: I am emulating another
site for testing purposes. Since the userid/password seems to be at the
Server level, and not a database level, it looks like I need to define
another server with a different userid/password combo. Is this right or am
I missing the boat?
(Yes, I need SQL Server security. I can't get by with Windows-only)
TIA,
Larry WoodsLogins are at the server level.
Users are at the database level.
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||> Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo.
You can create the desired login using a script like the one below.
EXEC sp_addlogin 'MyLogin', 'MyPassword'
USE MyDatabase
EXEC sp_adduser 'MyLogin'
--if role-based security
EXEC sp_addrolemember 'MyRole', 'MyLogin'
Hope this helps.
Dan Guzman
SQL Server MVP
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||O.K. Here is my situation. The ONLY SQL Server that I have defined was
defined with Windows-only security; therefore no SQL Server security. Now,
I need a SQL Server defined that has both Windows and SQL Server security.
That's why I "think" that I need to define a second server.
Make sense?
TIA,
Larry Woods
"Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> Logins are at the server level.
> Users are at the database level.
>
> "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
another
> am
>|||You can switch down from Windows only to Mixed Mode for your current server,
create an SQL Server login and do testings for that login, as you wish. Just
make sure you consider security in doing that, and make sure that you set a
password for sa before switching down. :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:e14MnO7%23DHA.2860@.tk2msftngp13.phx.gbl...
> O.K. Here is my situation. The ONLY SQL Server that I have defined was
> defined with Windows-only security; therefore no SQL Server security.
Now,
> I need a SQL Server defined that has both Windows and SQL Server security.
> That's why I "think" that I need to define a second server.
> Make sense?
> TIA,
> Larry Woods
> "Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
> news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
a
> another
the
define
or
>
Labels:
additional,
adifferent,
anothersite,
database,
defined,
emulating,
microsoft,
mysql,
oracle,
password,
server,
sql,
unique,
userid
I need to set up a ADDITIONAL server with unique userid/password. How?
I already have a SQL Server defined. I want to do some testing using a
different userid/password for the server. Reason: I am emulating another
site for testing purposes. Since the userid/password seems to be at the
Server level, and not a database level, it looks like I need to define
another server with a different userid/password combo. Is this right or am
I missing the boat?
(Yes, I need SQL Server security. I can't get by with Windows-only)
TIA,
Larry WoodsLogins are at the server level.
Users are at the database level.
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||> Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo.
You can create the desired login using a script like the one below.
EXEC sp_addlogin 'MyLogin', 'MyPassword'
USE MyDatabase
EXEC sp_adduser 'MyLogin'
--if role-based security
EXEC sp_addrolemember 'MyRole', 'MyLogin'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||O.K. Here is my situation. The ONLY SQL Server that I have defined was
defined with Windows-only security; therefore no SQL Server security. Now,
I need a SQL Server defined that has both Windows and SQL Server security.
That's why I "think" that I need to define a second server.
Make sense?
TIA,
Larry Woods
"Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> Logins are at the server level.
> Users are at the database level.
>
> "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > I already have a SQL Server defined. I want to do some testing using a
> > different userid/password for the server. Reason: I am emulating
another
> > site for testing purposes. Since the userid/password seems to be at the
> > Server level, and not a database level, it looks like I need to define
> > another server with a different userid/password combo. Is this right or
> am
> > I missing the boat?
> >
> > (Yes, I need SQL Server security. I can't get by with Windows-only)
> >
> > TIA,
> >
> > Larry Woods
> >
> >
>|||You can switch down from Windows only to Mixed Mode for your current server,
create an SQL Server login and do testings for that login, as you wish. Just
make sure you consider security in doing that, and make sure that you set a
password for sa before switching down. :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:e14MnO7%23DHA.2860@.tk2msftngp13.phx.gbl...
> O.K. Here is my situation. The ONLY SQL Server that I have defined was
> defined with Windows-only security; therefore no SQL Server security.
Now,
> I need a SQL Server defined that has both Windows and SQL Server security.
> That's why I "think" that I need to define a second server.
> Make sense?
> TIA,
> Larry Woods
> "Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
> news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> > Logins are at the server level.
> > Users are at the database level.
> >
> >
> > "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> > news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > I already have a SQL Server defined. I want to do some testing using
a
> > > different userid/password for the server. Reason: I am emulating
> another
> > > site for testing purposes. Since the userid/password seems to be at
the
> > > Server level, and not a database level, it looks like I need to
define
> > > another server with a different userid/password combo. Is this right
or
> > am
> > > I missing the boat?
> > >
> > > (Yes, I need SQL Server security. I can't get by with Windows-only)
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > >
> >
> >
>
different userid/password for the server. Reason: I am emulating another
site for testing purposes. Since the userid/password seems to be at the
Server level, and not a database level, it looks like I need to define
another server with a different userid/password combo. Is this right or am
I missing the boat?
(Yes, I need SQL Server security. I can't get by with Windows-only)
TIA,
Larry WoodsLogins are at the server level.
Users are at the database level.
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||> Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo.
You can create the desired login using a script like the one below.
EXEC sp_addlogin 'MyLogin', 'MyPassword'
USE MyDatabase
EXEC sp_adduser 'MyLogin'
--if role-based security
EXEC sp_addrolemember 'MyRole', 'MyLogin'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||O.K. Here is my situation. The ONLY SQL Server that I have defined was
defined with Windows-only security; therefore no SQL Server security. Now,
I need a SQL Server defined that has both Windows and SQL Server security.
That's why I "think" that I need to define a second server.
Make sense?
TIA,
Larry Woods
"Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> Logins are at the server level.
> Users are at the database level.
>
> "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > I already have a SQL Server defined. I want to do some testing using a
> > different userid/password for the server. Reason: I am emulating
another
> > site for testing purposes. Since the userid/password seems to be at the
> > Server level, and not a database level, it looks like I need to define
> > another server with a different userid/password combo. Is this right or
> am
> > I missing the boat?
> >
> > (Yes, I need SQL Server security. I can't get by with Windows-only)
> >
> > TIA,
> >
> > Larry Woods
> >
> >
>|||You can switch down from Windows only to Mixed Mode for your current server,
create an SQL Server login and do testings for that login, as you wish. Just
make sure you consider security in doing that, and make sure that you set a
password for sa before switching down. :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:e14MnO7%23DHA.2860@.tk2msftngp13.phx.gbl...
> O.K. Here is my situation. The ONLY SQL Server that I have defined was
> defined with Windows-only security; therefore no SQL Server security.
Now,
> I need a SQL Server defined that has both Windows and SQL Server security.
> That's why I "think" that I need to define a second server.
> Make sense?
> TIA,
> Larry Woods
> "Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
> news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> > Logins are at the server level.
> > Users are at the database level.
> >
> >
> > "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> > news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > I already have a SQL Server defined. I want to do some testing using
a
> > > different userid/password for the server. Reason: I am emulating
> another
> > > site for testing purposes. Since the userid/password seems to be at
the
> > > Server level, and not a database level, it looks like I need to
define
> > > another server with a different userid/password combo. Is this right
or
> > am
> > > I missing the boat?
> > >
> > > (Yes, I need SQL Server security. I can't get by with Windows-only)
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > >
> >
> >
>
I need to join some additional columns from SQL Server into the worksheet ...
Accounting has provided me with an Excel worksheet with several columns of
data, one of which is AccountID. There is a table in SQL Sever which also
has AccountID. I need to join (using AccountID) some additional columns from
SQL Server into the worksheet as new columns, save, and then send the
spreadsheet back to Accounting. What is the simplest method to accomplish
this? I would prefer a non programming approach with the fewest steps so
Accounting can do this themselves next time.DTS would be the easiest, if you can get the data into a staging table. Once
the resultset is generated you can get it back to the spreadsheet easily.
Alternatively, another "non programming approach" would be to use the rowset
provider OPENDATASOURCE. Check out the example in SQL Server Books Online
which shows how to use this with OLE DB provider for Jet.
Anith
data, one of which is AccountID. There is a table in SQL Sever which also
has AccountID. I need to join (using AccountID) some additional columns from
SQL Server into the worksheet as new columns, save, and then send the
spreadsheet back to Accounting. What is the simplest method to accomplish
this? I would prefer a non programming approach with the fewest steps so
Accounting can do this themselves next time.DTS would be the easiest, if you can get the data into a staging table. Once
the resultset is generated you can get it back to the spreadsheet easily.
Alternatively, another "non programming approach" would be to use the rowset
provider OPENDATASOURCE. Check out the example in SQL Server Books Online
which shows how to use this with OLE DB provider for Jet.
Anith
Subscribe to:
Posts (Atom)