Hi
I had windows integrated authication in directory
security in both folder reports and reportserver.
But I need reportserver as normal asp page so I just
changed to allow annoynymus access to reportserver folder.
So any once can access report using specifi url and it's
working without any problem.
But funny part is when I access
http://servername/reports (and logged in as administrator)
It doesnt show anything. Before that It was showing my
report and I could change and configure my report.
Please note that I didnt change any security setting in
reports folder and only thing I changed was allowing
annoynymus access to reporserver folder.
Any help would be grateful
Thanx
KenWhen you configure the Report Server for anonymous access, it will see the
requests coming under the anonymous account (IUSR_<computer name>) which
most likely doesn't have access to the report catalog in your case.
I would recommend you reconsider the Anonymous access strategy. When
Anonymous access is enabled, the Report Server won't be able to
differentiate the users which IMO is a recipe for a total chaos.
Not sure what you mean by I need reportserver as normal asp page.
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
www.manning.com/lachev
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:212b601c45a4c$15af4980$a101280a@.phx.gbl...
> Hi
> I had windows integrated authication in directory
> security in both folder reports and reportserver.
> But I need reportserver as normal asp page so I just
> changed to allow annoynymus access to reportserver folder.
> So any once can access report using specifi url and it's
> working without any problem.
> But funny part is when I access
> http://servername/reports (and logged in as administrator)
> It doesnt show anything. Before that It was showing my
> report and I could change and configure my report.
> Please note that I didnt change any security setting in
> reports folder and only thing I changed was allowing
> annoynymus access to reporserver folder.
> Any help would be grateful
> Thanx
> Ken
>
Showing posts with label folder. Show all posts
Showing posts with label folder. Show all posts
Monday, March 12, 2012
Saturday, February 25, 2012
Please help.....
We had a NT4 server with SQL 7 installed. AS it happened the machine complete
bombed out. I managed to copy the data folder from the SQL installation
diretory before the whole hdd went up in flames.
I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
and I really want to import this database into SQL 2000.
I have attached the database succefully and can see it there. Even the OBDC
test is successfull. However the application which is CRM Superoffice doens;t
want to log on as it says invalid username and password.
I am sure that I might have missed seomthing. Do I first need to some
coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
we no longer have SQL 7 but just the data directory of that installation. No
backups were done of this machine ( as usual )
Can I do anything at all?
Please, any help is appreciated.
Regards
Gian
Gian
Did you move all logins from source database to the destination?
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Sounds like the database is fine, but you may need to reattach database user
accounts.
See sp_change_users_login to see if you just need to realign the database
user accounts with the logins
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Hi,
Since you did an attach of databases, I am sure that you have not moved the
system databases from sql 7 to sql 2000.
All the SQL server logins will be kept in master database. So since you have
not copied the logins the SID in syslogins will not
match with SID in sysusers of each database. To resync the syslogins with
sysusers, refer the procedure "sp_change_users_login"
in sql server books online.
One more thing is after sync. you may need to make the CRM user to default
to that user database using the below system procedure
sp_defaultdb 'login_name','database_name'
Thanks
Hari
MCDBA
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Gian,
Things to check.
1) Did you import all the logins from the old server?
2) Are the logins mapped to the correct users in your attached database?
sp_change_users_login can help here.
3) Is the security mode the same as the old server? i.e. are you using
Windows Authentication Only or Mixed mode? Check that this is correct
because a standard SQL login will not be allowed on a Windows
Authentication Only server.
Also have a look at:
Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gian wrote:
> We had a NT4 server with SQL 7 installed. AS it happened the machine complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the OBDC
> test is successfull. However the application which is CRM Superoffice doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
> we no longer have SQL 7 but just the data directory of that installation. No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
bombed out. I managed to copy the data folder from the SQL installation
diretory before the whole hdd went up in flames.
I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
and I really want to import this database into SQL 2000.
I have attached the database succefully and can see it there. Even the OBDC
test is successfull. However the application which is CRM Superoffice doens;t
want to log on as it says invalid username and password.
I am sure that I might have missed seomthing. Do I first need to some
coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
we no longer have SQL 7 but just the data directory of that installation. No
backups were done of this machine ( as usual )
Can I do anything at all?
Please, any help is appreciated.
Regards
Gian
Gian
Did you move all logins from source database to the destination?
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Sounds like the database is fine, but you may need to reattach database user
accounts.
See sp_change_users_login to see if you just need to realign the database
user accounts with the logins
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Hi,
Since you did an attach of databases, I am sure that you have not moved the
system databases from sql 7 to sql 2000.
All the SQL server logins will be kept in master database. So since you have
not copied the logins the SID in syslogins will not
match with SID in sysusers of each database. To resync the syslogins with
sysusers, refer the procedure "sp_change_users_login"
in sql server books online.
One more thing is after sync. you may need to make the CRM user to default
to that user database using the below system procedure
sp_defaultdb 'login_name','database_name'
Thanks
Hari
MCDBA
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Gian,
Things to check.
1) Did you import all the logins from the old server?
2) Are the logins mapped to the correct users in your attached database?
sp_change_users_login can help here.
3) Is the security mode the same as the old server? i.e. are you using
Windows Authentication Only or Mixed mode? Check that this is correct
because a standard SQL login will not be allowed on a Windows
Authentication Only server.
Also have a look at:
Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gian wrote:
> We had a NT4 server with SQL 7 installed. AS it happened the machine complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the OBDC
> test is successfull. However the application which is CRM Superoffice doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
> we no longer have SQL 7 but just the data directory of that installation. No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
Please help.....
We had a NT4 server with SQL 7 installed. AS it happened the machine complete
bombed out. I managed to copy the data folder from the SQL installation
diretory before the whole hdd went up in flames.
I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
and I really want to import this database into SQL 2000.
I have attached the database succefully and can see it there. Even the OBDC
test is successfull. However the application which is CRM Superoffice doens;t
want to log on as it says invalid username and password.
I am sure that I might have missed seomthing. Do I first need to some
coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
we no longer have SQL 7 but just the data directory of that installation. No
backups were done of this machine ( as usual )
Can I do anything at all?
Please, any help is appreciated.
Regards
GianGian
Did you move all logins from source database to the destination?
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Sounds like the database is fine, but you may need to reattach database user
accounts.
See sp_change_users_login to see if you just need to realign the database
user accounts with the logins
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Hi,
Since you did an attach of databases, I am sure that you have not moved the
system databases from sql 7 to sql 2000.
All the SQL server logins will be kept in master database. So since you have
not copied the logins the SID in syslogins will not
match with SID in sysusers of each database. To resync the syslogins with
sysusers, refer the procedure "sp_change_users_login"
in sql server books online.
One more thing is after sync. you may need to make the CRM user to default
to that user database using the below system procedure
sp_defaultdb 'login_name','database_name'
Thanks
Hari
MCDBA
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Gian,
Things to check.
1) Did you import all the logins from the old server?
2) Are the logins mapped to the correct users in your attached database?
sp_change_users_login can help here.
3) Is the security mode the same as the old server? i.e. are you using
Windows Authentication Only or Mixed mode? Check that this is correct
because a standard SQL login will not be allowed on a Windows
Authentication Only server.
Also have a look at:
Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gian wrote:
> We had a NT4 server with SQL 7 installed. AS it happened the machine complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the OBDC
> test is successfull. However the application which is CRM Superoffice doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
> we no longer have SQL 7 but just the data directory of that installation. No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
bombed out. I managed to copy the data folder from the SQL installation
diretory before the whole hdd went up in flames.
I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
and I really want to import this database into SQL 2000.
I have attached the database succefully and can see it there. Even the OBDC
test is successfull. However the application which is CRM Superoffice doens;t
want to log on as it says invalid username and password.
I am sure that I might have missed seomthing. Do I first need to some
coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
we no longer have SQL 7 but just the data directory of that installation. No
backups were done of this machine ( as usual )
Can I do anything at all?
Please, any help is appreciated.
Regards
GianGian
Did you move all logins from source database to the destination?
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Sounds like the database is fine, but you may need to reattach database user
accounts.
See sp_change_users_login to see if you just need to realign the database
user accounts with the logins
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Hi,
Since you did an attach of databases, I am sure that you have not moved the
system databases from sql 7 to sql 2000.
All the SQL server logins will be kept in master database. So since you have
not copied the logins the SID in syslogins will not
match with SID in sysusers of each database. To resync the syslogins with
sysusers, refer the procedure "sp_change_users_login"
in sql server books online.
One more thing is after sync. you may need to make the CRM user to default
to that user database using the below system procedure
sp_defaultdb 'login_name','database_name'
Thanks
Hari
MCDBA
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian|||Gian,
Things to check.
1) Did you import all the logins from the old server?
2) Are the logins mapped to the correct users in your attached database?
sp_change_users_login can help here.
3) Is the security mode the same as the old server? i.e. are you using
Windows Authentication Only or Mixed mode? Check that this is correct
because a standard SQL login will not be allowed on a Windows
Authentication Only server.
Also have a look at:
Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gian wrote:
> We had a NT4 server with SQL 7 installed. AS it happened the machine complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the OBDC
> test is successfull. However the application which is CRM Superoffice doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
> we no longer have SQL 7 but just the data directory of that installation. No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
Subscribe to:
Posts (Atom)