Deployment to Production problems

Somewhat newbie here trying to deploy my first Report. Production machine is
on Windows 2003 - finally got around the reporting service prompting for
windows authentication and now I'm trying to deploy my report through VS
2003. Which reports successful deployment.
If I press the "Run" button in VS 2003 it displays a web page:
[To Parent Directory]
Tuesday, March 29, 2005... Name of my report
No fancy Reporting Service front end, just a hyperlink. If I click on the
link, it displays my report.
If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
the web page of SQL Server Reporting Services Home (with the appropriate
GUI), but no folders are listed.
There's obviously some extra step I need to do with 2003 that I didn't need
to setup on my local XP system that I developed and debugged on.Sounds like you haven't given permissions for anyone to see the reports. By
default, only admins can see contents of the server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"dtaylor" <dtaylor@.discussions.microsoft.com> wrote in message
news:F158F5D6-E52B-40F6-9F31-31C49358C33D@.microsoft.com...
> Somewhat newbie here trying to deploy my first Report. Production machine
> is
> on Windows 2003 - finally got around the reporting service prompting for
> windows authentication and now I'm trying to deploy my report through VS
> 2003. Which reports successful deployment.
> If I press the "Run" button in VS 2003 it displays a web page:
> [To Parent Directory]
> Tuesday, March 29, 2005... Name of my report
> No fancy Reporting Service front end, just a hyperlink. If I click on the
> link, it displays my report.
> If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
> the web page of SQL Server Reporting Services Home (with the appropriate
> GUI), but no folders are listed.
> There's obviously some extra step I need to do with 2003 that I didn't
> need
> to setup on my local XP system that I developed and debugged on.sql

Deployment options help!

Sorry I am a newbie in SSIS.

I have got a small project that requires to feed in a .CSV flat file and load the data into SQL server 2000.

I developed a SSIS package for this and get it working in my computer, but I need to deploy it to customers that they don't have VS 2005 or SSIS installed. May any one of you give me some clues on that?

I played around with the flat file deployment and again it seems only working on my computer as I have everything installed.

Did you read BOL?

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

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

or the SSIS management whitepaper?

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx

or other sources?

http://www.databasejournal.com/features/mssql/article.php/3600201

http://blogs.conchango.com/jamiethomson/archive/2006/01/23/2702.aspx

http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2902.aspx

I found these by typing "SSIS deployment" into Google. The help is there if you go and look for it.

-Jamie

Deploying the Personal Web Site

Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.

My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".

CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?

CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.

POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.

Color me "confused in Kauai" ... :) KevInKauai

Hi,

1.For your first question,the difference between "Personal" and "LocalSqlServer" is like the following:

Personal connectionStrings:"Data Source=localhost;Initial Catalog=CatelogName;uid=sa;password=XXX" (For other editions than the Express edition)

LocalSqlServer connectionString:"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" . (For SqlServer Express Edition)

2.For your second question,you can change the customErrors settings into the following mode if your hoster provide the authority.

<customErrors mode="off"/>

Thanks.

|||

Thanks, Jin !

My "VB guru days" were back with VB6 and I've taken a long hiatus, so I guess I'm suffering from object (or abject!) confusion. I've been trying to find the uttimate object reference but have only come up with this: http://quickstarts.asp.net/QuickStartv20/util/classbrowser.aspx

I've gone through all but the last 2 of the LearningVisualStudio (Express) videos and there really was never an application deployed in all of that.

Color me -- STILL WAY CONFUSED!

:) mahalos ... KevInKauai

deploying SQL server applications to another machine

Hi -
Let me start off by saying that I am a complete SQL server newbie.
I work with a system that uses SQL Server 2005 as it's backbone DB
running on W2K3 server. This system is going to be installed onto
customer servers, also running W2K3 server. Question is; is there a
way to deploy all aspects of JUST THE DB (tables, stored procedures,
security, users, etc...) to the customers servers without having to do
a full up install of SQL Server 2005 on every server that will host a
database?
ThanksYou need some process to read and interact with the database files. The only such process I know of
is ... SQL Server. Now, that can be Express edition, but it need to be some version of SQL Server...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ecfiedler@.impactsci.com> wrote in message
news:1179865512.394536.163730@.q69g2000hsb.googlegroups.com...
> Hi -
> Let me start off by saying that I am a complete SQL server newbie.
> I work with a system that uses SQL Server 2005 as it's backbone DB
> running on W2K3 server. This system is going to be installed onto
> customer servers, also running W2K3 server. Question is; is there a
> way to deploy all aspects of JUST THE DB (tables, stored procedures,
> security, users, etc...) to the customers servers without having to do
> a full up install of SQL Server 2005 on every server that will host a
> database?
> Thanks
>

deploying SQL server applications to another machine

Hi -
Let me start off by saying that I am a complete SQL server newbie.
I work with a system that uses SQL Server 2005 as it's backbone DB
running on W2K3 server. This system is going to be installed onto
customer servers, also running W2K3 server. Question is; is there a
way to deploy all aspects of JUST THE DB (tables, stored procedures,
security, users, etc...) to the customers servers without having to do
a full up install of SQL Server 2005 on every server that will host a
database?
Thanks
You need some process to read and interact with the database files. The only such process I know of
is ... SQL Server. Now, that can be Express edition, but it need to be some version of SQL Server...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ecfiedler@.impactsci.com> wrote in message
news:1179865512.394536.163730@.q69g2000hsb.googlegr oups.com...
> Hi -
> Let me start off by saying that I am a complete SQL server newbie.
> I work with a system that uses SQL Server 2005 as it's backbone DB
> running on W2K3 server. This system is going to be installed onto
> customer servers, also running W2K3 server. Question is; is there a
> way to deploy all aspects of JUST THE DB (tables, stored procedures,
> security, users, etc...) to the customers servers without having to do
> a full up install of SQL Server 2005 on every server that will host a
> database?
> Thanks
>

deploying SQL server applications to another machine

Hi -
Let me start off by saying that I am a complete SQL server newbie.
I work with a system that uses SQL Server 2005 as it's backbone DB
running on W2K3 server. This system is going to be installed onto
customer servers, also running W2K3 server. Question is; is there a
way to deploy all aspects of JUST THE DB (tables, stored procedures,
security, users, etc...) to the customers servers without having to do
a full up install of SQL Server 2005 on every server that will host a
database?
ThanksYou need some process to read and interact with the database files. The only
such process I know of
is ... SQL Server. Now, that can be Express edition, but it need to be some
version of SQL Server...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<ecfiedler@.impactsci.com> wrote in message
news:1179865512.394536.163730@.q69g2000hsb.googlegroups.com...
> Hi -
> Let me start off by saying that I am a complete SQL server newbie.
> I work with a system that uses SQL Server 2005 as it's backbone DB
> running on W2K3 server. This system is going to be installed onto
> customer servers, also running W2K3 server. Question is; is there a
> way to deploy all aspects of JUST THE DB (tables, stored procedures,
> security, users, etc...) to the customers servers without having to do
> a full up install of SQL Server 2005 on every server that will host a
> database?
> Thanks
>

Deploying Reports To Remote Locations

Hello,
I am a new SQL Reporting Services developer, and have a couple of newbie
questions.
1) I understand that SQL Reporting Services (SRS) is free with every
licensed copy of SQL Server 2000. I downloaded what appears to be an
"evaluation" copy of SRS. How do you install / license SRS on a server that
has a licensed copy of SQL Server 2000? Is there a separate download
media/CD? How do you license / activate SRS properly?
2) I would like to develop a SRS report remotely for a customer, and then
deploy it on their intranet at their location. Basically all development is
off-site, and I will travel onsite to install the completed SRS report. They
do not have a licensed copy of Visual Studio .NET, so none of the
development/maintenance will be done on their server. When I go to install
SRS on their server, I will only install the Server components, not the
client components. With that said, how do go about getting the actual report
installed / deployed on their server? I can do it locally on my development
box using "deploy" from within VS.NET, but how do I do it "manually" on a box
without VS.NET? What report "files" do I need to copy from my machine, and
what needs to be setup in IIS?
Thanks!You can order a CD with RS (i.e. a non-evaluation version). MSDN has it as
well.
There are no activation that occurs, just install it. You do have to have
the correct version of SQL Server when installing.
To deploy without you can script the deployment. I believe an example of
this ships with RS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> Hello,
> I am a new SQL Reporting Services developer, and have a couple of newbie
> questions.
> 1) I understand that SQL Reporting Services (SRS) is free with every
> licensed copy of SQL Server 2000. I downloaded what appears to be an
> "evaluation" copy of SRS. How do you install / license SRS on a server
that
> has a licensed copy of SQL Server 2000? Is there a separate download
> media/CD? How do you license / activate SRS properly?
> 2) I would like to develop a SRS report remotely for a customer, and then
> deploy it on their intranet at their location. Basically all development
is
> off-site, and I will travel onsite to install the completed SRS report.
They
> do not have a licensed copy of Visual Studio .NET, so none of the
> development/maintenance will be done on their server. When I go to install
> SRS on their server, I will only install the Server components, not the
> client components. With that said, how do go about getting the actual
report
> installed / deployed on their server? I can do it locally on my
development
> box using "deploy" from within VS.NET, but how do I do it "manually" on a
box
> without VS.NET? What report "files" do I need to copy from my machine, and
> what needs to be setup in IIS?
> Thanks!|||Thanks for the quick reply Bruce!
I'll see if I can get the "offical" version via MSDN.
I'll check out the scripting example. Hope it's not too involved. I figured
that it would not be as straight forward as copying a few files.
- Bill
"Bruce L-C [MVP]" wrote:
> You can order a CD with RS (i.e. a non-evaluation version). MSDN has it as
> well.
> There are no activation that occurs, just install it. You do have to have
> the correct version of SQL Server when installing.
> To deploy without you can script the deployment. I believe an example of
> this ships with RS.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > Hello,
> >
> > I am a new SQL Reporting Services developer, and have a couple of newbie
> > questions.
> >
> > 1) I understand that SQL Reporting Services (SRS) is free with every
> > licensed copy of SQL Server 2000. I downloaded what appears to be an
> > "evaluation" copy of SRS. How do you install / license SRS on a server
> that
> > has a licensed copy of SQL Server 2000? Is there a separate download
> > media/CD? How do you license / activate SRS properly?
> >
> > 2) I would like to develop a SRS report remotely for a customer, and then
> > deploy it on their intranet at their location. Basically all development
> is
> > off-site, and I will travel onsite to install the completed SRS report.
> They
> > do not have a licensed copy of Visual Studio .NET, so none of the
> > development/maintenance will be done on their server. When I go to install
> > SRS on their server, I will only install the Server components, not the
> > client components. With that said, how do go about getting the actual
> report
> > installed / deployed on their server? I can do it locally on my
> development
> > box using "deploy" from within VS.NET, but how do I do it "manually" on a
> box
> > without VS.NET? What report "files" do I need to copy from my machine, and
> > what needs to be setup in IIS?
> >
> > Thanks!
>
>|||The reason it is not just copying files is that your rdl files do not exist
on the server (search it, you won't find them). The reports are stored in
the database.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
news:2E52E77E-7D1E-4490-8820-B480DD3250C4@.microsoft.com...
> Thanks for the quick reply Bruce!
> I'll see if I can get the "offical" version via MSDN.
> I'll check out the scripting example. Hope it's not too involved. I
figured
> that it would not be as straight forward as copying a few files.
> - Bill
> "Bruce L-C [MVP]" wrote:
> > You can order a CD with RS (i.e. a non-evaluation version). MSDN has it
as
> > well.
> >
> > There are no activation that occurs, just install it. You do have to
have
> > the correct version of SQL Server when installing.
> >
> > To deploy without you can script the deployment. I believe an example of
> > this ships with RS.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > > Hello,
> > >
> > > I am a new SQL Reporting Services developer, and have a couple of
newbie
> > > questions.
> > >
> > > 1) I understand that SQL Reporting Services (SRS) is free with every
> > > licensed copy of SQL Server 2000. I downloaded what appears to be an
> > > "evaluation" copy of SRS. How do you install / license SRS on a server
> > that
> > > has a licensed copy of SQL Server 2000? Is there a separate download
> > > media/CD? How do you license / activate SRS properly?
> > >
> > > 2) I would like to develop a SRS report remotely for a customer, and
then
> > > deploy it on their intranet at their location. Basically all
development
> > is
> > > off-site, and I will travel onsite to install the completed SRS
report.
> > They
> > > do not have a licensed copy of Visual Studio .NET, so none of the
> > > development/maintenance will be done on their server. When I go to
install
> > > SRS on their server, I will only install the Server components, not
the
> > > client components. With that said, how do go about getting the actual
> > report
> > > installed / deployed on their server? I can do it locally on my
> > development
> > > box using "deploy" from within VS.NET, but how do I do it "manually"
on a
> > box
> > > without VS.NET? What report "files" do I need to copy from my machine,
and
> > > what needs to be setup in IIS?
> > >
> > > Thanks!
> >
> >
> >|||It appears that the Report Manager browser interface allows you to upload an
RDL file from a file system directly into the Report Server database. Very
cool!
But... I imagine that since the data source info is different between the
two environments (production server versus development laptop) and since the
RDL contains the data source definition, this might not work 100%. Still need
to do some more digging. Perhaps you can change the data source for a report
once it's been uploaded into the production server.
"Bruce L-C [MVP]" wrote:
> The reason it is not just copying files is that your rdl files do not exist
> on the server (search it, you won't find them). The reports are stored in
> the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> news:2E52E77E-7D1E-4490-8820-B480DD3250C4@.microsoft.com...
> > Thanks for the quick reply Bruce!
> >
> > I'll see if I can get the "offical" version via MSDN.
> >
> > I'll check out the scripting example. Hope it's not too involved. I
> figured
> > that it would not be as straight forward as copying a few files.
> >
> > - Bill
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You can order a CD with RS (i.e. a non-evaluation version). MSDN has it
> as
> > > well.
> > >
> > > There are no activation that occurs, just install it. You do have to
> have
> > > the correct version of SQL Server when installing.
> > >
> > > To deploy without you can script the deployment. I believe an example of
> > > this ships with RS.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > > news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > > > Hello,
> > > >
> > > > I am a new SQL Reporting Services developer, and have a couple of
> newbie
> > > > questions.
> > > >
> > > > 1) I understand that SQL Reporting Services (SRS) is free with every
> > > > licensed copy of SQL Server 2000. I downloaded what appears to be an
> > > > "evaluation" copy of SRS. How do you install / license SRS on a server
> > > that
> > > > has a licensed copy of SQL Server 2000? Is there a separate download
> > > > media/CD? How do you license / activate SRS properly?
> > > >
> > > > 2) I would like to develop a SRS report remotely for a customer, and
> then
> > > > deploy it on their intranet at their location. Basically all
> development
> > > is
> > > > off-site, and I will travel onsite to install the completed SRS
> report.
> > > They
> > > > do not have a licensed copy of Visual Studio .NET, so none of the
> > > > development/maintenance will be done on their server. When I go to
> install
> > > > SRS on their server, I will only install the Server components, not
> the
> > > > client components. With that said, how do go about getting the actual
> > > report
> > > > installed / deployed on their server? I can do it locally on my
> > > development
> > > > box using "deploy" from within VS.NET, but how do I do it "manually"
> on a
> > > box
> > > > without VS.NET? What report "files" do I need to copy from my machine,
> and
> > > > what needs to be setup in IIS?
> > > >
> > > > Thanks!
> > >
> > >
> > >
>
>|||The best way to do this is to used shared datasource. I never define a
datasource for a particular report. I might have two shared datasources in a
project though. Then you have your shared datasource be defined differently
on your development machine than it is in production. Only the name of the
shared datasource needs to stay the same.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
news:0A2723EB-5411-44CE-843C-0EEDDFDD75BF@.microsoft.com...
> It appears that the Report Manager browser interface allows you to upload
an
> RDL file from a file system directly into the Report Server database. Very
> cool!
> But... I imagine that since the data source info is different between the
> two environments (production server versus development laptop) and since
the
> RDL contains the data source definition, this might not work 100%. Still
need
> to do some more digging. Perhaps you can change the data source for a
report
> once it's been uploaded into the production server.
> "Bruce L-C [MVP]" wrote:
> > The reason it is not just copying files is that your rdl files do not
exist
> > on the server (search it, you won't find them). The reports are stored
in
> > the database.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > news:2E52E77E-7D1E-4490-8820-B480DD3250C4@.microsoft.com...
> > > Thanks for the quick reply Bruce!
> > >
> > > I'll see if I can get the "offical" version via MSDN.
> > >
> > > I'll check out the scripting example. Hope it's not too involved. I
> > figured
> > > that it would not be as straight forward as copying a few files.
> > >
> > > - Bill
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You can order a CD with RS (i.e. a non-evaluation version). MSDN has
it
> > as
> > > > well.
> > > >
> > > > There are no activation that occurs, just install it. You do have to
> > have
> > > > the correct version of SQL Server when installing.
> > > >
> > > > To deploy without you can script the deployment. I believe an
example of
> > > > this ships with RS.
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > >
> > > > "Smit-Dog" <SmitDog@.discussions.microsoft.com> wrote in message
> > > > news:6160D0B2-2F39-4176-B2F1-D3D4AA24982C@.microsoft.com...
> > > > > Hello,
> > > > >
> > > > > I am a new SQL Reporting Services developer, and have a couple of
> > newbie
> > > > > questions.
> > > > >
> > > > > 1) I understand that SQL Reporting Services (SRS) is free with
every
> > > > > licensed copy of SQL Server 2000. I downloaded what appears to be
an
> > > > > "evaluation" copy of SRS. How do you install / license SRS on a
server
> > > > that
> > > > > has a licensed copy of SQL Server 2000? Is there a separate
download
> > > > > media/CD? How do you license / activate SRS properly?
> > > > >
> > > > > 2) I would like to develop a SRS report remotely for a customer,
and
> > then
> > > > > deploy it on their intranet at their location. Basically all
> > development
> > > > is
> > > > > off-site, and I will travel onsite to install the completed SRS
> > report.
> > > > They
> > > > > do not have a licensed copy of Visual Studio .NET, so none of the
> > > > > development/maintenance will be done on their server. When I go to
> > install
> > > > > SRS on their server, I will only install the Server components,
not
> > the
> > > > > client components. With that said, how do go about getting the
actual
> > > > report
> > > > > installed / deployed on their server? I can do it locally on my
> > > > development
> > > > > box using "deploy" from within VS.NET, but how do I do it
"manually"
> > on a
> > > > box
> > > > > without VS.NET? What report "files" do I need to copy from my
machine,
> > and
> > > > > what needs to be setup in IIS?
> > > > >
> > > > > Thanks!
> > > >
> > > >
> > > >
> >
> >
> >

Deny remote access to MSDE for some users

HI!
I'm a complete MSDE newbie but I have to clarify an open question about
access control with MSDE 2000 running on WinNT 4.0:
Is it possible to grant some admin users remote access to the MSDE but
restrict other local users to local access?
Ciao, Michael.
hi Michael,
Michael Strder wrote:
> HI!
> I'm a complete MSDE newbie but I have to clarify an open question
> about access control with MSDE 2000 running on WinNT 4.0:
> Is it possible to grant some admin users remote access to the MSDE but
> restrict other local users to local access?
yes, of course..
you have to grant the remote logins access to the MSDE instance via the
sp_grantlogin system stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_ga-gz_8dri.asp), while you have to deny local logins via sp_denylogin...
please have a look at
http://support.microsoft.com/default...;EN-US;q325003 for futher
info about how to perform these tasks via oSql.exe, the command line tool
provided with MSDE
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
first many thanks for the pointers.
Andrea Montanari wrote:
> hi Michael,
> Michael Strder wrote:
> you have to grant the remote logins access to the MSDE instance via the
> sp_grantlogin system stored procedure
> (http://msdn.microsoft.com/library/de...-us/tsqlref/ts
> _sp_ga-gz_8dri.asp), while you have to deny local logins via sp_denylogin...
Let's assume I use Windows authentication for MSDE. Is the whole access
control also done via Windows rights based on groups? How to disallow a
remote login for local users then?
Ciao, Michael.
|||ciao Michael,
> ..
> Let's assume I use Windows authentication for MSDE. Is the whole
> access control also done via Windows rights based on groups? How to
> disallow a remote login for local users then?
let's say you have YourDomain\theUser member of TheGroup\
you want TheGroup\ to be able to connect to MSDE, so you grant
(sp_grantlogin) it connection...
but you want YourDomain\theUser not to be able to connect to MSDE .. you
deny YourDomain\theUser connection to MSDE via sp_denylogin...
this way you have YourDomain\TheGroup able to connect and YourDomain\theUser
unable...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply