Dreaded "SQL Server does not exist or access denied. " Error

I have built a web application that runs on my local web server against my local SQL server and my development server, but now I'm trying to get it to work on the live server and I'm not getting a connection. Whenever I try to open the connection, I get a.

SQL Server does not exist or access denied.

error.

Here is my connection string...

Public connString as string

Dim SQLServerAsString = "xxx.xx.xx.xxx"

connString = "server=" & SQLServer & ";" _

& "database=DBName;Trusted_Connection=No;user id=xxxID;password=xxxPassword;"

myConnection2 =New SqlClient.SqlConnection(connString)

------------------

I'm starting my connection to run a datareader this way...

Dim strSQLAsString

strSQL = "SELECT ClientID, ClientName " & _

"FROM Client; "

' Create a connection to the table in the SQL database located on

' the remote computer.

Dim myCommand2AsNew SqlClient.SqlCommand(strSQL, myConnection2)

myCommand2.CommandTimeout = 1200

myConnection2.Open() 'HERE IS WHERE THE ERROR OCCURS

Dim myReaderAs SqlClient.SqlDataReader = myCommand2.ExecuteReader(CommandBehavior.CloseConnection)

While myReader.Read()

-------------------

I can communicate with the server with no problem from my local computer. I can ping the server, and I also tested it by creating a system DSN using the login and password in my application, and it finds the database with no problem. I've tried to connect using the SQL Server's server name and the IP address and both return the same result. I've also saw something in another post to set the trusted connection parameter to "yes" and that didn't work either.

I'm developing on a Windows XP Professional and I'm trying to connect to a Windows 2003 Server with SQL Server 2000 installed on the machine.

I did add the database by restoring a backup from my local server onto the live server. I don't think that should matter, but maybe it does. If anyone has any ideas, I would greatly appreciate it.

Try adding this to the end of your connection string and see if it makes a difference:

;Network Library =dbmssocn

This will force a TCP/IP connection instead of a named pipes connection.

(fromBUG: Named pipes do not work when worker process runs under ASPNET account)|||Thanks for the suggestion. Unfortunately that didn't work. Could there be some server firewall setting that is preventing the web user account from accessing the server?|||I would also try adding a port number to the end of the IP address:

Dim SQLServerAsString = "xxx.xx.xx.xxx,1433"

And I would remove Trusted_Connection=No completely. Seehttp://www.connectionstrings.comfor connection string examples. If none of that works, perhapsthe user ID and password are incorrect? Sorry, just grasping atstraws. My last recommendation is to review this KB article:Potential causes of the "SQL Server does not exists or access denied" error message. As you'll see, there are a lot of things to check.|||Thanks for your help. It looks like the problem stemmed from a security hole in Windows 2003 Server, which was shutting down the TCP ports. We applied SP4 and it seems to be working for now. Hopefully that's all it was.

Dragging multiple fields to a table?

Ok, there has to be a way of dragging multiple fields from a dataset
to a table like there is in Access. I have a dataset of about 30-40
columns and it will be excruciating to right click on a column in the
table 30-40 times to add more columns so that I can then drag one at a
time all the fields to each new column.
Please tell me that I don't have to do this one by one. Thanks for
any input.You can drag one field at a time from the field list and drop it in the
cell. You don't to right-click on the cell and add it through the
expression builder. you can select multiple fields and drag&drop them but I
don't think that will work unless your using a list.
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0407211308.39c6da3a@.posting.google.com...
> Ok, there has to be a way of dragging multiple fields from a dataset
> to a table like there is in Access. I have a dataset of about 30-40
> columns and it will be excruciating to right click on a column in the
> table 30-40 times to add more columns so that I can then drag one at a
> time all the fields to each new column.
> Please tell me that I don't have to do this one by one. Thanks for
> any input.

Downsizing to Access?

Hi,
Does anyone happen to know if it is possible to downsize a SQL Server
database to an Access mdb file? The reason I ask is because I want to use an
mdb file to transport the SQL Server database from a to b, and then upsize
the mdb database to SQL Server.
Unless there is an easier way to transport SQL Server databases including
views and stored procedures?
Thanks all
SimonTry sp_detach_db and sp_attach_db.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:%23Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use
an
> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>|||Look into sp_detach_db and sp_attach_db in BOL.
This will allow you to transport the db with ease.
-Lars
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:%23Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use
an
> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>|||Attach, detach does NOT work to copy SQL databases into an access MDB unless
I have really missed the boat... I would probably use DTS and pick sql as
the source and Access as the destination...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:#Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use
an
> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>|||From your question is sounded like you were trying to transfer a database
from one MSSQL server to another using an Access database as the transfer
media. If that is the case then I would ditch using Access and just detach
the database from the source, copy to the destination and re-attach the
database.
Jim
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message
news:uDorHDp5DHA.2300@.TK2MSFTNGP10.phx.gbl...
> Attach, detach does NOT work to copy SQL databases into an access MDB
unless
> I have really missed the boat... I would probably use DTS and pick sql as
> the source and Access as the destination...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> (Please respond only to the newsgroups.)
> I support the Professional Association for SQL Server
> (www.sqlpass.org)
> "Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
> news:#Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Does anyone happen to know if it is possible to downsize a SQL Server
> > database to an Access mdb file? The reason I ask is because I want to
use
> an
> > mdb file to transport the SQL Server database from a to b, and then
upsize
> > the mdb database to SQL Server.
> >
> > Unless there is an easier way to transport SQL Server databases
including
> > views and stored procedures?
> >
> > Thanks all
> >
> > Simon
> >
> >
>

Downsizing to Access?

Hi,
Does anyone happen to know if it is possible to downsize a SQL Server
database to an Access mdb file? The reason I ask is because I want to use an
mdb file to transport the SQL Server database from a to b, and then upsize
the mdb database to SQL Server.
Unless there is an easier way to transport SQL Server databases including
views and stored procedures?
Thanks all
SimonTry sp_detach_db and sp_attach_db.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:%23Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use

---

an

quote:

---

> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>

---

|||Look into sp_detach_db and sp_attach_db in BOL.
This will allow you to transport the db with ease.
-Lars
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:%23Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use

---

an

quote:

---

> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>

---

|||Attach, detach does NOT work to copy SQL databases into an access MDB unless
I have really missed the boat... I would probably use DTS and pick sql as
the source and Access as the destination...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:#Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi,
> Does anyone happen to know if it is possible to downsize a SQL Server
> database to an Access mdb file? The reason I ask is because I want to use

---

an

quote:

---

> mdb file to transport the SQL Server database from a to b, and then upsize
> the mdb database to SQL Server.
> Unless there is an easier way to transport SQL Server databases including
> views and stored procedures?
> Thanks all
> Simon
>

---

|||From your question is sounded like you were trying to transfer a database
from one MSSQL server to another using an Access database as the transfer
media. If that is the case then I would ditch using Access and just detach
the database from the source, copy to the destination and re-attach the
database.
Jim
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message
news:uDorHDp5DHA.2300@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Attach, detach does NOT work to copy SQL databases into an access MDB

---

unless

quote:

---

> I have really missed the boat... I would probably use DTS and pick sql as
> the source and Access as the destination...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> (Please respond only to the newsgroups.)
> I support the Professional Association for SQL Server
> (www.sqlpass.org)
> "Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
> news:#Lik0fo5DHA.2380@.TK2MSFTNGP10.phx.gbl...
use[QUOTE]
> an
upsize[QUOTE]
including[QUOTE]
>

---

download location

We own SQL 2000 Std server license.
We'd like to get access to Reporting Services for SQL2k. Where can I
download? (all i can find is the download to the trial)Did you get any response on this
I'm in the same boat, I can find the Service Packs, but I can't find the
base software.
Any direction will be much appreciated.
"john doe" wrote:
> We own SQL 2000 Std server license.
> We'd like to get access to Reporting Services for SQL2k. Where can I
> download? (all i can find is the download to the trial)
>
>

Downgrading SQLServer to MSDE

Hi,
I am pretty new to MSDE and am just researching options for writing a .NET
version of a desktop application (currently VB6 / Access).
There is a web version of our product available already which has a SQL
Server backend.
I am figuring that I will use MSDE so I can use all their Stored procedures
and as much code of theirs as possible.
What I am wondering is if I can get downgrade from SQL Server to MSDE ?
There's lots of information about upgrading, but nothing about downgrading.
Thanks
Sanj
hi,
Sanjit Suchak wrote:
> Hi,
> I am pretty new to MSDE and am just researching options for writing a
> .NET version of a desktop application (currently VB6 / Access).
> There is a web version of our product available already which has a
> SQL Server backend.
> I am figuring that I will use MSDE so I can use all their Stored
> procedures and as much code of theirs as possible.
> What I am wondering is if I can get downgrade from SQL Server to MSDE
> ? There's lots of information about upgrading, but nothing about
> downgrading.
downgrading is a viable solution as long as you take into consideration all
relevant MSDE limitations..
2gb database size, limited replication support, no OLAP features, no
Reporting Services... and limited number of users scenarios... these are the
most relevant of them in my opinion... but the core features are all
available...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Down to 1 line now

'So whats the SQL server 2005 Express Edition gonna be called here?

sub openconn ' open a connection to access db'
dim tries
set conn = CreateObject("ADODB.Connection") 'prep connection'
set rs = CreateObject("ADODB.Recordset") ' prep recordset'
tries = 0 ' clear tries counter'
do 'try to open connection to the db
conn.open "DRIVER={Microsoft Access Driver (*.mdb)};" &_ 'CHANGE THIS STRING FOR SQL CONNECTION
"DBQ=" & RouteFile & ";DefaultDir=;UID=;PWD=;"
tries = tries + 1
if (err.number <> 0) then 'if errored, close this connection
conn.close
end if
Loop While (Err.Number<>0) And tries < 10 'if errored, try again. MAX TRIES = 10
end sub

Look at www.connectionstrings.com, I put some samples on there using SQL Server 2000 backwards functionality and additional using SNAC feature for SQL Server 2005 (Express)

HTH, Jens Suessmeyer.

Down Sizing from SQL server to MSDE?

Hi everyone,
Does anyone know if I can take tables from SQL server and somehow get them
into MSDE. I'm using Access as a front end to both servers. I know there is
a way to upsize databases, as well there should be, but what are my options
in terms of downsizing?
Thanks everyone
Take Care
SimonScripting the tables and then using INSERT INTO should work fine.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Simon Harvey" <sh856531@.microsofts_free_emal_service.com> wrote in message
news:SerXa.52566$9C6.3100247@.wards.force9.net...
> Hi everyone,
> Does anyone know if I can take tables from SQL server and somehow get them
> into MSDE. I'm using Access as a front end to both servers. I know there
is
> a way to upsize databases, as well there should be, but what are my
options
> in terms of downsizing?
> Thanks everyone
> Take Care
> Simon
>|||I think I'd try sp_detachdb and sp_attachdb and see if that works ( it
should I think.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Simon Harvey" <sh856531@.microsofts_free_emal_service.com> wrote in message
news:SerXa.52566$9C6.3100247@.wards.force9.net...
> Hi everyone,
> Does anyone know if I can take tables from SQL server and somehow get them
> into MSDE. I'm using Access as a front end to both servers. I know there
is
> a way to upsize databases, as well there should be, but what are my
options
> in terms of downsizing?
> Thanks everyone
> Take Care
> Simon
>

Double left joins with conditions

I have a setup in an Access database with linked tables to Oracle (its a remote application database that is synced when a connection is available). I have to perform inserts, updates, and deletes based upon records that have changed since the last update. In the examples of inserting records into oracle, I find records in access that do not exist in oracle and meet the date condition. Where I run into problems are in tables like [events]: I need to only be updating, inserting, and deleting events for a specific county but the only place county is designated is in the location table that events are tied to through lctn_id. I just can't figure out how to involve the location table join with the events table join and the necessary conditions.

locations (and locations_ora)
lctn_id, cnty_nbr, lctn_nm..., rec_dt

events (and events_ora)
evnt_id, lctn_id, evnt_txt, ..., rec_dt

Example of format used for another table:
INSERT INTO locations_ora SELECT DISTINCTROW a.* FROM locations a LEFT JOIN locations o ON a.lctn_id=o.lctn_id WHERE (o.lctn_id IS NULL) AND a.rec_dt>#8/17/2000 1:11:11 AM# AND a.cnty_nbr=5

How I would like to get events working:
INSERT INTO events_ora SELECT DISTINCTROW a.* FROM events AS a LEFT JOIN events_ora AS o ON a.evnt_id=o.evnt_id WHERE (o.evnt_id IS NULL) AND a.rec_dt>#8/17/2000 1:11:11 AM# AND {some way to only get events tied locations in a specific county}
-- or even --
INSERT INTO events_ora SELECT DISTINCTROW a.* FROM (SELECT a.* FROM events a LEFT JOIN locations l ON b.lctn_id=l.lctn_id WHERE l.cnty_nbr=5 ) LEFT JOIN events_ora o ON a.evnt_id=o.evnt_id WHERE (o.evnt_id IS NULL) AND a.rec_dt>#1/17/1979 1:11:11 AM#
(I thought this one would work but Access blows up on the SELECT after the FROM.)

Can anyone point me in the right direction?INSERT
INTO events_ora
SELECT a.*
FROM (
events a
inner
JOIN locations l
ON (
l.lctn_id = a.lctn_id
and l.cnty_nbr = 5
)
)
LEFT
JOIN events_ora o
ON o.evnt_id = a.evnt_id
WHERE a.rec_dt>#1/17/1979|||The traffic signals of North Carolina thank you immensely!

Seeing how this is done correctly and in the reading I've done on your site (since I figured you would be the likely responder to my thread) has definitely increased my understanding of how to work with SQL. You will now be added to the Whiteboard of Fame in conference room C-011.|||thanks :)

that's the nicest kudos i've received in a while

dont permit manual access to database

I've got a java application that connects to a sql server 2000
database.
The application must access with total permissions to database but I
don't want that anybody can insert or delete data with the corporative
administrator of sql server 2000.
How can I lock the corporative administrator in order to not permit
manual manipulation but my application can work properly?
Thanks!There's no way to prevent a sysadmin from accessing a database. You
don't say why you want to do this, but if it's to stop someone seeing
sensitive data, then encryption is probably the best solution:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22

Simon

Domino VBA

Hi,
I am trying to read data from a domino databases (located in our LAN
not on my local machine!) from my access project. I pass a code to the
function checkCodeInDomino to be verified on Domino. On my local
machine everything went fine, but suddenly there came up following
problem:

I was coding and testing with the code below, and I have never been
asked for my lotus password, now when starting my function, there comes
a box up (dont know why this changed?) where I have to enter my lotus
password, when entering my notes password, my function works fine.
But I have to distribute my application to other clients and users, and
it doesnt make sense to use my password.
So I received a public account from our domino admin, for all of us.
When using "DomSession.Initialize (publicLotusPassword)" there are no
errors.
But the problem is, that that's not a real solution for my
appliacation, because each user has to enter his own password, I dont
want that,
but entering a hard coded password doesnt work, because the password
that is asked is referring to
"c:\lotus\notes\data\wk\$userName.ID"

Is there any way to use "DomSession.Initialize" in some kind of a
"generic" way, so that any other user can use the function
"checkCodeInDomino"?
Please remember that the domino database is always on a remote machine
and
"'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
does not work!

Here is my code...

Function checkCodeInDomino(checkCode As Long)
On Error GoTo Err_Quit_Click

Dim DomDir As NotesDatabase
Dim DomContacts As NotesView
Dim DomDoc As NotesDocument
Dim StrName As String

Dim DomSession As NotesSession
Dim serverName As String
Dim databaseFile As String

Set DomSession = CreateObject("Lotus.NotesSession")
serverName = "myServerName"
databaseFile = "myFile"

DomSession.Initialize

Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
Set DomContacts = DomDir.GetView("myView")
Set DomDoc = DomContacts.GetFirstDocument

While Not (DomDoc Is Nothing)

If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
checkCodeInDomino = True
Exit Function
End If
Set DomDoc = DomContacts.GetNextDocument(DomDoc)
Wend

checkCodeInDomino = False

Exit_Quit_Click:
Exit Function

Err_Quit_Click:
MsgBox Err.Description
Resume Exit_Quit_Click

End Function

Thank you for your attention!

Peter NeumaierI think you'll have more luck asking in a newsgroup related to Notes or
Domino, as opposed to a database group.

Have you tried looking for documentation at http://www.lotus.com?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
news:1112392663.538812.206890@.g14g2000cwa.googlegr oups.com...
> Hi,
> I am trying to read data from a domino databases (located in our LAN
> not on my local machine!) from my access project. I pass a code to the
> function checkCodeInDomino to be verified on Domino. On my local
> machine everything went fine, but suddenly there came up following
> problem:
> I was coding and testing with the code below, and I have never been
> asked for my lotus password, now when starting my function, there comes
> a box up (dont know why this changed?) where I have to enter my lotus
> password, when entering my notes password, my function works fine.
> But I have to distribute my application to other clients and users, and
> it doesnt make sense to use my password.
> So I received a public account from our domino admin, for all of us.
> When using "DomSession.Initialize (publicLotusPassword)" there are no
> errors.
> But the problem is, that that's not a real solution for my
> appliacation, because each user has to enter his own password, I dont
> want that,
> but entering a hard coded password doesnt work, because the password
> that is asked is referring to
> "c:\lotus\notes\data\wk\$userName.ID"
> Is there any way to use "DomSession.Initialize" in some kind of a
> "generic" way, so that any other user can use the function
> "checkCodeInDomino"?
> Please remember that the domino database is always on a remote machine
> and
> "'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
> does not work!
> Here is my code...
> Function checkCodeInDomino(checkCode As Long)
> On Error GoTo Err_Quit_Click
> Dim DomDir As NotesDatabase
> Dim DomContacts As NotesView
> Dim DomDoc As NotesDocument
> Dim StrName As String
> Dim DomSession As NotesSession
> Dim serverName As String
> Dim databaseFile As String
> Set DomSession = CreateObject("Lotus.NotesSession")
> serverName = "myServerName"
> databaseFile = "myFile"
> DomSession.Initialize
> Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
> Set DomContacts = DomDir.GetView("myView")
> Set DomDoc = DomContacts.GetFirstDocument
> While Not (DomDoc Is Nothing)
> If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
> checkCodeInDomino = True
> Exit Function
> End If
> Set DomDoc = DomContacts.GetNextDocument(DomDoc)
> Wend
> checkCodeInDomino = False
> Exit_Quit_Click:
> Exit Function
> Err_Quit_Click:
> MsgBox Err.Description
> Resume Exit_Quit_Click
> End Function
> Thank you for your attention!
> Peter Neumaier|||Hi Douglas,

thank you for your answer, but I think that my problem is more VBA and
ACCES than it is to domino databases.

So the only problem I have to solve is, how to use a default password
when accessing the domino database ...

For sure I found documentation on lotus.com, but there isnt anything
regarding my problem

"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message news:<0cCdnUdLW-09ddDfRVn-vA@.rogers.com>...
> I think you'll have more luck asking in a newsgroup related to Notes or
> Domino, as opposed to a database group.
> Have you tried looking for documentation at http://www.lotus.com?
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
> news:1112392663.538812.206890@.g14g2000cwa.googlegr oups.com...
> > Hi,
> > I am trying to read data from a domino databases (located in our LAN
> > not on my local machine!) from my access project. I pass a code to the
> > function checkCodeInDomino to be verified on Domino. On my local
> > machine everything went fine, but suddenly there came up following
> > problem:
> > I was coding and testing with the code below, and I have never been
> > asked for my lotus password, now when starting my function, there comes
> > a box up (dont know why this changed?) where I have to enter my lotus
> > password, when entering my notes password, my function works fine.
> > But I have to distribute my application to other clients and users, and
> > it doesnt make sense to use my password.
> > So I received a public account from our domino admin, for all of us.
> > When using "DomSession.Initialize (publicLotusPassword)" there are no
> > errors.
> > But the problem is, that that's not a real solution for my
> > appliacation, because each user has to enter his own password, I dont
> > want that,
> > but entering a hard coded password doesnt work, because the password
> > that is asked is referring to
> > "c:\lotus\notes\data\wk\$userName.ID"
> > Is there any way to use "DomSession.Initialize" in some kind of a
> > "generic" way, so that any other user can use the function
> > "checkCodeInDomino"?
> > Please remember that the domino database is always on a remote machine
> > and
> > "'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
> > does not work!
> > Here is my code...
> > Function checkCodeInDomino(checkCode As Long)
> > On Error GoTo Err_Quit_Click
> > Dim DomDir As NotesDatabase
> > Dim DomContacts As NotesView
> > Dim DomDoc As NotesDocument
> > Dim StrName As String
> > Dim DomSession As NotesSession
> > Dim serverName As String
> > Dim databaseFile As String
> > Set DomSession = CreateObject("Lotus.NotesSession")
> > serverName = "myServerName"
> > databaseFile = "myFile"
> > DomSession.Initialize
> > Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
> > Set DomContacts = DomDir.GetView("myView")
> > Set DomDoc = DomContacts.GetFirstDocument
> > While Not (DomDoc Is Nothing)
> > If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
> > checkCodeInDomino = True
> > Exit Function
> > End If
> > Set DomDoc = DomContacts.GetNextDocument(DomDoc)
> > Wend
> > checkCodeInDomino = False
> > Exit_Quit_Click:
> > Exit Function
> > Err_Quit_Click:
> > MsgBox Err.Description
> > Resume Exit_Quit_Click
> > End Function
> > Thank you for your attention!
> > Peter Neumaier|||While I recognize that you're experiencing the problem using automation from
VBA, you're still issuing commands to directly to Domino. I would think that
people more familiar with the Domino programming model would be better able
to help than people familiar with VBA.

YMMV, though.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
news:98284637.0504020824.4b7a20c9@.posting.google.c om...
> Hi Douglas,
> thank you for your answer, but I think that my problem is more VBA and
> ACCES than it is to domino databases.
> So the only problem I have to solve is, how to use a default password
> when accessing the domino database ...
> For sure I found documentation on lotus.com, but there isnt anything
> regarding my problem
>
> "Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
> news:<0cCdnUdLW-09ddDfRVn-vA@.rogers.com>...
>> I think you'll have more luck asking in a newsgroup related to Notes or
>> Domino, as opposed to a database group.
>>
>> Have you tried looking for documentation at http://www.lotus.com?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
>> news:1112392663.538812.206890@.g14g2000cwa.googlegr oups.com...
>> > Hi,
>> > I am trying to read data from a domino databases (located in our LAN
>> > not on my local machine!) from my access project. I pass a code to the
>> > function checkCodeInDomino to be verified on Domino. On my local
>> > machine everything went fine, but suddenly there came up following
>> > problem:
>>> > I was coding and testing with the code below, and I have never been
>> > asked for my lotus password, now when starting my function, there comes
>> > a box up (dont know why this changed?) where I have to enter my lotus
>> > password, when entering my notes password, my function works fine.
>> > But I have to distribute my application to other clients and users, and
>> > it doesnt make sense to use my password.
>> > So I received a public account from our domino admin, for all of us.
>> > When using "DomSession.Initialize (publicLotusPassword)" there are no
>> > errors.
>> > But the problem is, that that's not a real solution for my
>> > appliacation, because each user has to enter his own password, I dont
>> > want that,
>> > but entering a hard coded password doesnt work, because the password
>> > that is asked is referring to
>> > "c:\lotus\notes\data\wk\$userName.ID"
>>> > Is there any way to use "DomSession.Initialize" in some kind of a
>> > "generic" way, so that any other user can use the function
>> > "checkCodeInDomino"?
>> > Please remember that the domino database is always on a remote machine
>> > and
>> > "'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
>> > does not work!
>>> > Here is my code...
>>> > Function checkCodeInDomino(checkCode As Long)
>> > On Error GoTo Err_Quit_Click
>>> > Dim DomDir As NotesDatabase
>> > Dim DomContacts As NotesView
>> > Dim DomDoc As NotesDocument
>> > Dim StrName As String
>>> > Dim DomSession As NotesSession
>> > Dim serverName As String
>> > Dim databaseFile As String
>>> > Set DomSession = CreateObject("Lotus.NotesSession")
>> > serverName = "myServerName"
>> > databaseFile = "myFile"
>>> > DomSession.Initialize
>>> > Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
>> > Set DomContacts = DomDir.GetView("myView")
>> > Set DomDoc = DomContacts.GetFirstDocument
>>> > While Not (DomDoc Is Nothing)
>>> > If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
>> > checkCodeInDomino = True
>> > Exit Function
>> > End If
>> > Set DomDoc = DomContacts.GetNextDocument(DomDoc)
>> > Wend
>>> > checkCodeInDomino = False
>>> > Exit_Quit_Click:
>> > Exit Function
>>> > Err_Quit_Click:
>> > MsgBox Err.Description
>> > Resume Exit_Quit_Click
>>> > End Function
>>> > Thank you for your attention!
>>> > Peter Neumaier
>

Domain group server access?

Hi,
If a user needs access to a databases and I carry out the following steps:
1) Create a domain group
2) Put the users login details in this group
3) Give the domain group access to SQL Server via Enterprise Manager
4) Give the domain group database access via Enterprise Manager
Do I also need to give this domain group direct server access by adding it
to a group in:
Computer Management\Local Users and Groups\Groups ?
Ta
wendyalso, we are using active directory.
wendy
"Woo" wrote:

> Hi,
> If a user needs access to a databases and I carry out the following steps:
> 1) Create a domain group
> 2) Put the users login details in this group
> 3) Give the domain group access to SQL Server via Enterprise Manager
> 4) Give the domain group database access via Enterprise Manager
> Do I also need to give this domain group direct server access by adding it
> to a group in:
> Computer Management\Local Users and Groups\Groups ?
> Ta
> wendy|||No you don't need to give OS level permissions on the server
that is running SQL Server for the group to access SQL
Server. You only need to add the windows group to the SQL
Server logins (and whatever databases).
-Sue
On Fri, 3 Nov 2006 04:14:02 -0800, Woo
<Woo@.discussions.microsoft.com> wrote:

>Hi,
>If a user needs access to a databases and I carry out the following steps:
>1) Create a domain group
>2) Put the users login details in this group
>3) Give the domain group access to SQL Server via Enterprise Manager
>4) Give the domain group database access via Enterprise Manager
>Do I also need to give this domain group direct server access by adding it
>to a group in:
>Computer Management\Local Users and Groups\Groups ?
>Ta
>wendy|||And you will have to give the windows group permissions to access tables,
views, stored procedures, etc.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:bcjmk2h4eoundvep74genb5d43ldjveog2@.
4ax.com...
> No you don't need to give OS level permissions on the server
> that is running SQL Server for the group to access SQL
> Server. You only need to add the windows group to the SQL
> Server logins (and whatever databases).
> -Sue
> On Fri, 3 Nov 2006 04:14:02 -0800, Woo
> <Woo@.discussions.microsoft.com> wrote:
>
>

Domain group accounts

I have a problem with database access that I would like to sort out.
1. I gave a Windows 2003 server with SQL 2000 (SP3)
2. I decided to create different Windows Groups and add Windows accounts to
them to access different databases
3. This is where it starts giving me problem
4. I noticed that user belonging to one group (ie. database1 access) also
had access to database2
4. To test this I created a group called Test and addedd this to
Security/logins in Enterprise Manager and assigned this group access to
database1
5. I placed my own account into this group and that gave me access to all
other databases as well, even though the group Test is only set to
database1.
What is problem here'
OweTry running xp_logininfo to report the permission path(s) for the account.
For example
EXEC master..xp_logininfo 'MyDomain\Test', 'all'
For a Windows authenticated user to gain access to a database, one of the
following must be true:
- the account was granted database access
- the account is member of a Windows group than was granted database access
- the account is the database owner
- the account is a member of a sysadmin fixed server role
- the guest account is enabled in the database
Hope this helps.
Dan Guzman
SQL Server MVP
"Owe Armandt" <owe.armandt@.visma.se> wrote in message
news:ugQDkVnyFHA.2696@.TK2MSFTNGP10.phx.gbl...
>I have a problem with database access that I would like to sort out.
> 1. I gave a Windows 2003 server with SQL 2000 (SP3)
> 2. I decided to create different Windows Groups and add Windows accounts
> to them to access different databases
> 3. This is where it starts giving me problem
> 4. I noticed that user belonging to one group (ie. database1 access) also
> had access to database2
> 4. To test this I created a group called Test and addedd this to
> Security/logins in Enterprise Manager and assigned this group access to
> database1
> 5. I placed my own account into this group and that gave me access to all
> other databases as well, even though the group Test is only set to
> database1.
> What is problem here'
>
> Owe
>|||I helped a bit, I will test further tomorrow.
I found out that I (my windows account) happend to be owner of the database.
I have now changed the owner to 'sa' and then I get access only if the group
I belong to is set to have DB access.
One thing bothers me though, my college do not belong to any group that has
access to any database and still he could access the database that I was the
owner of.
I don't think he is part of admin ro anything, we try to kep our avccounts
clear in order to be as alike the users account as possible.
This is what I will try to check out tomorrow - I will be back tomorrow with
some info
Owe
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> skrev i meddelandet
news:OzfN9jnyFHA.464@.TK2MSFTNGP15.phx.gbl...
> Try running xp_logininfo to report the permission path(s) for the account.
> For example
> EXEC master..xp_logininfo 'MyDomain\Test', 'all'
> For a Windows authenticated user to gain access to a database, one of the
> following must be true:
> - the account was granted database access
> - the account is member of a Windows group than was granted database
> access
> - the account is the database owner
> - the account is a member of a sysadmin fixed server role
> - the guest account is enabled in the database
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Owe Armandt" <owe.armandt@.visma.se> wrote in message
> news:ugQDkVnyFHA.2696@.TK2MSFTNGP10.phx.gbl...
>

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.

Domain Group Account Won''t Work

Greetings,

I am trying to configure Reporting Services to allow a domain group access to reports. I am able to configure the domain and group (mydomain\grpname) in both Report Manager and BIDS. I'm sure I entered the correct name because I purposely misspelled it and received an error. I think this tells me it is finding the group correctly.

However, when my test user goes to Report Manager, there are no folders displayed. I checked and he is in the domain group I am using. If I explicitly add him (mydomain\andy) to the folders, he can see them and execute the reports.

After searching the forums and other websites, I have checked IIS is using Windows Integrated Security and not anonymous access.

Any ideas?

Rob

Hi Rob,

Have you verified the domain account was granted access to the (root) home folder. To check, open up Report Manager (Web interface) and on the home page click on properties and verify the domain account is listed and that it has at least Browser rights. If you do not see the group listed, then click on New Role Assignment and add the domain group and grant Browser rights.

|||

Yes, the domain group has Browser permissions to the Home folder.

I am concerned that the server itself may not be properly configured to access the domain groups. Would it be fair to say that because using a domain USER works, using a domain GROUP should work as well? Or could there be some other Windows Server 2003 setting that needs to be configured?

Rob

|||

If you are not getting errors when granting rights to the group, then that part should be fine. Windows 2000 and 2003 use Active Directory and Reporting Services is of course Active Directory aware. I believe you are saying that your server is Windows 2003 and that is good. However, are your user accounts using Active Directory or are they possibly members of a legacy Windows NT domain? I have had problems with this in the past and we had to migrate all Windows NT domain accounts to Windows 2003 Active Directory accounts.

|||

UPDATE: It would appear that Active Directory is NOT installed afterall. (I need to stop relying upon other people to answer my questions.)

I'm guessing AD needs to be installed. Correct?

If so, I may have a problem. Being one of those "big corporations" we have an IT department that doesn't really support us having our own servers. I'm going to give it a try. Hopefully I won't be fired.

Rob

|||

Rob,

I would be very careful before installing Active Directory on your database server unless you plan to have a self-contained network of your own. Active Directory does not need to be installed on your server, but your server does need to be registered in your corporate Active Directory schema for it to be recognized by Active Directory and able to grant AD account access to your Reporting Services. Check with your I.T. folks to ensure your server is registered and has this ability. No one wants anyone to get fired.

|||

Chuck,

I'll try to check with IT. They can be a bit stubborn about this stuff and not share any information. I wouldn't be surprised if we are running legacy Windows NT domains considering we only went to Exchange 2003 less than a year ago.

Rob

|||

Also, on your server you can right-click on the My Computer icon and choose properties to see what Domain it shows your sever to be a member of. That information would be useful for both yourself and the I.T. staff.