Showing posts with label create. Show all posts
Showing posts with label create. Show all posts

Tuesday, March 27, 2012

Cannot drop type

Cannot drop a type event though it is not in use.

The type was created via create type and is an non-nullable nvarchar. It should have been nullable.

I have removed all dependencies on the type, by dropping tabes, stored procs etc, but still cannot drop it. SSMSE says the type cannot be dropped because it's in use. SSMSE shows no dependencies on the type.

Any help?

Can you run these queries

select object_name(object_id), * from sys.columns where user_type_id=type_id('Your_type_name')

select object_name(object_id), * from sys.parameters where user_type_id=type_id('Your_type_name')

and see if they return any rows back. If they do then there are still some dependencies left in the database on the type. The object_id is the object which has those dependencies.

Thanks

Asvin

|||

Many thanks Asvin, that got it.

Turned out an old view was still referencing the type. Strange that SSMSE did not see this dependency.

|||

Also, check out this very good blog by Umachandar titled "Direct Dependencies on column"

http://blogs.msdn.com/sqltips/archive/2005/07/05/435882.aspx

Cannot drop type

Cannot drop a type event though it is not in use.

The type was created via create type and is an non-nullable nvarchar. It should have been nullable.

I have removed all dependencies on the type, by dropping tabes, stored procs etc, but still cannot drop it. SSMSE says the type cannot be dropped because it's in use. SSMSE shows no dependencies on the type.

Any help?

Can you run these queries

select object_name(object_id), * from sys.columns where user_type_id=type_id('Your_type_name')

select object_name(object_id), * from sys.parameters where user_type_id=type_id('Your_type_name')

and see if they return any rows back. If they do then there are still some dependencies left in the database on the type. The object_id is the object which has those dependencies.

Thanks

Asvin

|||

Many thanks Asvin, that got it.

Turned out an old view was still referencing the type. Strange that SSMSE did not see this dependency.

|||

Also, check out this very good blog by Umachandar titled "Direct Dependencies on column"

http://blogs.msdn.com/sqltips/archive/2005/07/05/435882.aspx

Sunday, March 25, 2012

Cannot drop Temporary Table linked to Connection

Hi there!

I have a Java-Servlet that opens a connection to a SQL-Server 2000
With this connection I create a temporary local table.
I can call the temporary table within this connection as often as I want ... it's there as long as the connection is open. It's not dropped automatically as long as the connection is open. But when want to drop that table MANUALLY, I get a

[Microsoft][SQLServer JDBC Driver][SQLServer]Cannot drop the table '#tablename', because it does not exist in the system catalog.

I don't use any stored procedures that could drop the table before I do.
The database is accessed only by "normal" sql-statements through the JDBC-Driver. I can read the content of the table 10 times but if I try to drop it just in the next line, I get the above error message.

Now I know that the table will be dropped as soon as I close the connection, but anyway it's safer to do it manually ... so has somebody an idea?

Thanks

LookDo you need repeated access to the temp table or is it used just once ? Also, can you send the code you are using ? Is it straight sql or are you using a stored procedure (it appears that you are doing straight sql)?|||Found this in MSDN. Look for the article "Coding T-SQL like an Expert"

IF (object_id('tempdb..#mytemp') IS not Null)
Drop Table #mytemp

Although `tempdb..#authors_temp' is a truncation of the actual physical name of the object as held in tempdb..sysobjects, somehow OBJECT_ID() recognizes that you mean "your" temporary table called #mytemp.

Cannot Drop Index and PK Constraints

I am trying to create a new column on a table, but realized that there is already an PK index created. I am unable to drop the PK, or even delete the table. I also am unable to delete the index.Please be more specific - what error messages are you receiving ? Is it because of a system error or a constraint error (like you are deleting a primary key which is a foreign key in another table(s)) ?

Cannot deploy to RS2K from Visual Studio 2005

I started using Visual Studio 2005 and when trying to create a SQL Report and
deploy it to a SQL RS 2000 I get this error message "the attemp to connect to
the report server failed. Checked your connection information and that the
report server is a compatible version.
(Microsoft.ReportingServices.Designer)".
Does that mean Visual Studio 2005 is not backward compatible with SQRS2000?
or do I have to modify something in the config of VS2005?
Any ideas?
CarlosYou can deploy 2000 reports to 2005. You cannot deploy 2005 reports to 2000
server.
2005 is backward compatible in the sense that you don't have to modify any
2000 reports for the report to work in 2005 server. However, to use the new
features (multi-select parameters, user run-time sorting etc) you have to
convert the report.
If you think about it, how would 2005 be able to deploy with a 2000 server.
2000 knows nothing about the new features.
You can run side by side for development. If you have to deploy to 2000 then
you need to install RS 2000 report designer and VS 2003 to host the
designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Carlos" <carlosarango@.SQLserver.com> wrote in message
news:D638ACB1-553D-4AE4-B87F-156C9E622A79@.microsoft.com...
>I started using Visual Studio 2005 and when trying to create a SQL Report
>and
> deploy it to a SQL RS 2000 I get this error message "the attemp to connect
> to
> the report server failed. Checked your connection information and that the
> report server is a compatible version.
> (Microsoft.ReportingServices.Designer)".
> Does that mean Visual Studio 2005 is not backward compatible with
> SQRS2000?
> or do I have to modify something in the config of VS2005?
> Any ideas?
> Carlos|||Thanks Bruce
"Bruce L-C [MVP]" wrote:
> You can deploy 2000 reports to 2005. You cannot deploy 2005 reports to 2000
> server.
> 2005 is backward compatible in the sense that you don't have to modify any
> 2000 reports for the report to work in 2005 server. However, to use the new
> features (multi-select parameters, user run-time sorting etc) you have to
> convert the report.
> If you think about it, how would 2005 be able to deploy with a 2000 server.
> 2000 knows nothing about the new features.
> You can run side by side for development. If you have to deploy to 2000 then
> you need to install RS 2000 report designer and VS 2003 to host the
> designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Carlos" <carlosarango@.SQLserver.com> wrote in message
> news:D638ACB1-553D-4AE4-B87F-156C9E622A79@.microsoft.com...
> >I started using Visual Studio 2005 and when trying to create a SQL Report
> >and
> > deploy it to a SQL RS 2000 I get this error message "the attemp to connect
> > to
> > the report server failed. Checked your connection information and that the
> > report server is a compatible version.
> > (Microsoft.ReportingServices.Designer)".
> >
> > Does that mean Visual Studio 2005 is not backward compatible with
> > SQRS2000?
> > or do I have to modify something in the config of VS2005?
> >
> > Any ideas?
> >
> > Carlos
>
>

Tuesday, March 20, 2012

Cannot Crete server object

I'm using a client software to connect to a server. Everytime I try to log in
to that software an error: " ERROR 70: Cannot Create Servre Object". I
currently use a Microsoft Advanced server with the clients having a WIndows
XP OS.
What do I need to do?
Contact your Software Vendor. It is not a SQL Server error, but an error
that is only understood by the vendor.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"thescene" <thescene@.discussions.microsoft.com> wrote in message
news:8C17E98A-A16F-4EEF-AE8F-D32F851B63F7@.microsoft.com...
> I'm using a client software to connect to a server. Everytime I try to log
> in
> to that software an error: " ERROR 70: Cannot Create Servre Object". I
> currently use a Microsoft Advanced server with the clients having a
> WIndows
> XP OS.
> What do I need to do?
|||I just changed my switch, is that a possible reason why it's not working
anymore?
Joseph
"Mike Epprecht (SQL MVP)" wrote:

> Contact your Software Vendor. It is not a SQL Server error, but an error
> that is only understood by the vendor.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "thescene" <thescene@.discussions.microsoft.com> wrote in message
> news:8C17E98A-A16F-4EEF-AE8F-D32F851B63F7@.microsoft.com...
>
>
sql

Cannot create view WITH VIEW_METADATA

I'm trying to create a view and make it updatable using an INSTEAD OF UPDATE trigger. This works OK on SQL Server 2005 (even with compatibility level 80), but on SQL Server 2000 I receive an error message:

"Could not perform CREATE VIEW because WITH VIEW_METADATA was specified and the view is not updatable."

The following sql reproduces the problem.

CREATE TABLE test (a int, b int)
go
INSERT INTO test VALUES(1,0)
INSERT INTO test VALUES(2,0)
INSERT INTO test VALUES(3,1)
INSERT INTO test VALUES(3,1)
go

CREATE VIEW testview WITH VIEW_METADATA AS
SELECT a,SUM(b) b FROM test GROUP BY a
go

CREATE TRIGGER TR_testview_U ON testview INSTEAD OF UPDATE AS
BEGIN
UPDATE test SET b=inserted.b
FROM test INNER JOIN inserted ON test.a = inserted.a
END
go

SELECT * FROM test
SELECT * FROM testview
UPDATE testview SET b=2 WHERE a=3
SELECT * FROM test
SELECT * FROM testview
go

DROP VIEW testview
DROP TABLE test

I want my view to be updatable so I can use it in my VB6/ADO application, and the trigger won't fire unless I specify VIEW_METADATA.

When you create any view with following operation (operator/clause) , that view will be become as NOT UPDATEABLE VIWE, when it is not UPDATABLE you can’t specify the WITH VIEW_METADATA.

TOP,

GROUP BY,

UNION

DISTINCT

|||Thanks for the reply. As I said in SQL Server 2005 this works, just wondering why not in SQL Server 2000 - WITH VIEW_METADATA is precisely for making non UPDATABLE views updatable, according to BOL

"When a view is created by using WITH VIEW_METADATA, all its columns, except a timestamp column, are updatable if the view has INSTEAD OF INSERT or INSTEAD OF UPDATE triggers."

which seems to imply that the columns wouldn't have been updatable without VIEW_METADATA.

Cannot create variable of type table

Hi all,
Just heard of table-type variables and wanted to try one out in a SP
(MS-SQL Server 7.0).
However, every time I try to declare such a variable as, (for instance)
:
declare @.mytbl table(pos_num smallint, seq_num smallint)
I get an error :
Error 156: Incorrect syntax near the word 'table' .
Any ideas as to what the problem here might be (I have full admin
rights on this particular database)?
TIA, RobertSQL Server 7.0 doesnt know about table variables:
http://developer.com/db/article.php/3414331
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"robertino" <rbanfield@.telair.com> schrieb im Newsbeitrag
news:1117443939.893947.77470@.g44g2000cwa.googlegroups.com...
> Hi all,
> Just heard of table-type variables and wanted to try one out in a SP
> (MS-SQL Server 7.0).
> However, every time I try to declare such a variable as, (for instance)
> :
> declare @.mytbl table(pos_num smallint, seq_num smallint)
> I get an error :
> Error 156: Incorrect syntax near the word 'table' .
> Any ideas as to what the problem here might be (I have full admin
> rights on this particular database)?
> TIA, Robert
>|||Table variables are not supported in7.0. They are available in SQL Server
2000.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"robertino" <rbanfield@.telair.com> wrote in message
news:1117443939.893947.77470@.g44g2000cwa.googlegroups.com...
Hi all,
Just heard of table-type variables and wanted to try one out in a SP
(MS-SQL Server 7.0).
However, every time I try to declare such a variable as, (for instance)
:
declare @.mytbl table(pos_num smallint, seq_num smallint)
I get an error :
Error 156: Incorrect syntax near the word 'table' .
Any ideas as to what the problem here might be (I have full admin
rights on this particular database)?
TIA, Robert|||Hmmm, just as I suspected - we have here SQL Server 2000 clients
running as frontends to a SQL Server 7 DB. Phooey! (Been on holiday, so
haven't been able to reply until now.)
Robert
Tom Moreau wrote:
> Table variables are not supported in7.0. They are available in SQL Server
> 2000.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "robertino" <rbanfield@.telair.com> wrote in message
> news:1117443939.893947.77470@.g44g2000cwa.googlegroups.com...
> Hi all,
> Just heard of table-type variables and wanted to try one out in a SP
> (MS-SQL Server 7.0).
> However, every time I try to declare such a variable as, (for instance)
> :
> declare @.mytbl table(pos_num smallint, seq_num smallint)
> I get an error :
> Error 156: Incorrect syntax near the word 'table' .
> Any ideas as to what the problem here might be (I have full admin
> rights on this particular database)?
> TIA, Robert

Cannot create user on Report Server 2005

Hi, we installed SQL Server 2005 & Reporting Services on a box that had been
running 2000.
I launched the reports website.
When I try to do New System Role Assignment, I type in a domain user and
select a role and click OK, nothing at all happens. No error message, no
response, nothing.
Does anyone have any idea what might be going on?What I tend to do is create a local group and add my domain users to the
local group. Two things to try. Did you put the domain in front of the user?
I.e. MyDomain\Username
Second, are you in the local administrators group. Perhaps you don't have
rights to be doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RebeccaTS" <RebeccaTS@.discussions.microsoft.com> wrote in message
news:730D7944-B019-4E7A-8B9C-EA7EEB33486A@.microsoft.com...
> Hi, we installed SQL Server 2005 & Reporting Services on a box that had
> been
> running 2000.
> I launched the reports website.
> When I try to do New System Role Assignment, I type in a domain user and
> select a role and click OK, nothing at all happens. No error message, no
> response, nothing.
> Does anyone have any idea what might be going on?

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
..Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
Tamer
I was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:

> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamer

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
.Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
TamerI was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:

> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU
.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamersql

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
.Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
TamerI was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:
> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamer

Cannot Create System DSN

Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
dsn's that are already created. I begin to create it, and
it says it already exists, "overwrite?". (this is because
I have already tried creating it with that name, and am
using the same dsn name. If I use a new name, I don't get
the "already exists" message, but the following problem
still occurs.) I do so, and continue through creating the
dsn and successfully testing the connection. When I
finish the creation, the dsn name still does not appear in
the list of system dsn's. Is this a corrupt odbc database
on the win2K machine? I have no idea!!! PS I am tryiing
to create it with local Administrator priveledges.
Any help would be appreciated.
Thanks
David
Check the permissions on the following registry key:
HKLM\Software\ODBC\ODBC.INI
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I'm also experiencing the same problem. I've checked the permissions on the related key in the registry, and have given Full Permission to all users, but to no avail. Any other suggestions?
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Cannot Create System DSN

Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
dsn's that are already created. I begin to create it, and
it says it already exists, "overwrite?". (this is because
I have already tried creating it with that name, and am
using the same dsn name. If I use a new name, I don't get
the "already exists" message, but the following problem
still occurs.) I do so, and continue through creating the
dsn and successfully testing the connection. When I
finish the creation, the dsn name still does not appear in
the list of system dsn's. Is this a corrupt odbc database
on the win2K machine? I have no idea!!! PS I am tryiing
to create it with local Administrator priveledges.
Any help would be appreciated.
Thanks
DavidCheck the permissions on the following registry key:
HKLM\Software\ODBC\ODBC.INI
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I'm also experiencing the same problem. I've checked the permissions on the
related key in the registry, and have given Full Permission to all users, bu
t to no avail. Any other suggestions?
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Cannot create subscriptions from Management Studio

I cannot create any subscriptions from Management Studio.
Reports have shared Data Source with stored credentials
SQL Agent is up and running
In surface area configuration "Scheduling and delivery" for SSRS are enabled
SSRS Execution account has been set up
E-mail settings are fine
I'm logged in as Admin, able to everything, but...
When I right-click on report/subscriptions folder, both "New subscription"
and "New data driven subscription" are DISABLED.
What's wrong? That's driving me crazy!
DmitryHello Dmitry,
I would like to know, when you try to use the Report Manager Via web
interface,
If you try to use the Report Manager via web and create the subscription,
what's the result?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOpkHyeGIHA.4268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I would like to know, when you try to use the Report Manager Via web
> interface,
> If you try to use the Report Manager via web and create the subscription,
> what's the result?
I am using custom (forms) security and the admin can only log in through
Management Studio. For security purposes (this is internet-faced
application) no separate login pages for SSRS exist.
Regular users (authenticated and authorized) can see the reports inside web
application via ReportViewer control, which is getting the instance of
IReportServerCredentials.
Regards,
Dmitry|||Hello Dmitry,
Well, since you are using the form authentication, the management studio
may not connect to the reporting services correctly.
I would like to know whether the admin account you use have the proper
permission of reporting services.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:bIg%23C9rGIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Well, since you are using the form authentication, the management studio
> may not connect to the reporting services correctly.
> I would like to know whether the admin account you use have the proper
> permission of reporting services.
Yes, the admin is in any possible role. I already mentioned that in my
initial message. I'm able to do everything that's not subscriptions related.
Subscription-related menu items are simply disabled and I need to know why.
Dmitry.|||Hello Dmitry,
The admin you use is a domain account or a form authentication account?
Have you checked what's the role of this account on the reporting services?
Is it a System admin ?
Also, for the report, does it have the Manage all subscriptions permission?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:2rG$mH3GIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> The admin you use is a domain account or a form authentication account?
There's no such account technically. Admin is authenticated by
username/password inside forms security extension and after that it is given
unlimited access in any CheckAccess method...
> Have you checked what's the role of this account on the reporting
> services?
I answered this question already:
System User
System Administrator
Browser
Content Manager
Publisher
Report Builder
> Is it a System admin ?
Yes.
> Also, for the report, does it have the Manage all subscriptions
> permission?
Through Content Manager role, yes
As a matter of fact I have just installed the second instance of RS with
standard security and all the defaults. And I observe the same damn thing:
subscription related menu items are disabled in Management studio, but I can
create subscriptions using the same Windows credentials in the browser.
Which tells me the original issue may be not related to my custom security
extension at all.
Regards,
Dmitry|||Hello Dmitry,
Could you please let me know the config file content?
rsreportserver.config and RSWebApplication.config under the ReportManager
and Reporserver folder is appreicated.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:p$%23GYM5GIHA.5176@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you please let me know the config file content?
> rsreportserver.config and RSWebApplication.config under the ReportManager
> and Reporserver folder is appreicated.
E-mail delivery of those files failed. Please provide valid e-mail address.
The following message to <weilu@.online.microsoft.com> was undeliverable.
The reason for the problem:
5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com
(MX): NXDomain'|||Hello Dmitry,
Please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dmitry,
I get your email.
I would like to suggest you check the web services account you use.
Could you please change it to the network services?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7mWE3N4HIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I get your email.
> I would like to suggest you check the web services account you use.
> Could you please change it to the network services?
Please advise WHERE EXACTLY this change to be made.
D.|||Hello Dmitry,
There is an element in the reportserver.config file:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
Please modify it like this.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:R78DbCCIIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> There is an element in the reportserver.config file:
> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
> Please modify it like this.
It is configured to be running as MYPCNAME\ASPNET
If I modify "like this" I'm getting the following message while trying to
navigate to any folder in Management Studio:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--
ADDITIONAL INFORMATION:
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Report Services SOAP Proxy Source)
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Microsoft.ReportingServices.Diagnostics)
D.|||Hello Dmitry,
I am performing some test on my side. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dima,
I would like to know whether you have applied the latest service pack of
sql server and have you stored the credential for the report.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:K1afiFOLIHA.6908@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dima,
> I would like to know whether you have applied the latest service pack of
> sql server
It is 9.00.3054.00
> and have you stored the credential for the report.
There is no such thing as "stored credential for the report"
If you mean "stored credentials for the DATA SOURCE", yes that's the case.
Dmitry|||Hello Dmitry,
Could you lease send me an email and that I may involve other resources?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:j33I7UmMIHA.4380@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you lease send me an email and that I may involve other resources?
Wei,
I sent you the e-mail a week ago. Where are those "other resourses"?
D.|||Hello,
My colleague is Out of Office. Once he is back, I will escalate this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot create subscription in with Report Manager

While on the Report Delivery Options page if I click "Select Schedule" or
"OK" nothing happens; no error message, no postback, nothing in the logs,
nothing in a SQL Trace. I cannot create a File Share nor an e-mail
subcription.
I am able to programmaticaly (using ReportServer WebService and
ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
ideas?have you checked who you are logged into report manager as. What user. do
they have permissions to create a schedule?
"mbianco21" wrote:
> While on the Report Delivery Options page if I click "Select Schedule" or
> "OK" nothing happens; no error message, no postback, nothing in the logs,
> nothing in a SQL Trace. I cannot create a File Share nor an e-mail
> subcription.
> I am able to programmaticaly (using ReportServer WebService and
> ASP.NET/VB.NET) create a subscription but not with the Report Manager. Any
> ideas?sql

Cannot create subscription for a SQL Server 2005 Mobile database

I have been trying for almost 2 days now to create a subscription to a
SQL Server 2005 database but I haven't had any success. After reading
all of the documentation and installing everything, the problem seems
to have something to do with permissions. Here is what works:
* Created the a merge publication and checked to see that the
Replication Monitor shows that it works.
* Checked the directory where the snapshot files are located and they
exist.
* Can access the snapshot files from a browser, so I know security is
setup
* Tried setting the account for IIS 6.0 on the virtual directory to my
Windows account which has full admin permissions. Even tried
anonymous.
* Set the permission on all of the files and directories where the
snapshot files are stored.
* Added my Windows account to the PAL in the publication.
* Added my Windows account to the SQL Server login accounts
I then created an empty SQL Server 2005 mobile database locally on my
PC. Then I accessed it in SQL Server Management Studio.
Finally, I selected the New Subscription Wizard on the node of my
mobile database and tried using all kinds of login accounts.
Where it hangs is when I get to the last screen where it attempts to
create the subscription. After hanging several seconds on the part
that says "Synchronizing Data", it comes back with an error message
that either tells me that the SQL Server does not exist and/or the
user account does not exist. If I try screwing around with the various
types of login accounts, it can sometimes come back and say the IIS
account is not in SQL Server. There are a lot of accounts to setup
everywhere - publiccations, distributor, IIS, the database. Man, this
is getting to be one ugly headache. Can someone please give me some
solid steps on how to create a subscription.
Much appreciated,
Johann
I would first rule out publication properties. In SSMS create a local
sdf/mobile database and pull to it. If this works your publication is OK.
Then examine the IIS logs to see where it is getting stuck. Chances are it
is a permissions/authentication problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Polaris431" <polaris431@.gmail.com> wrote in message
news:1173019861.533730.317880@.n33g2000cwc.googlegr oups.com...
>I have been trying for almost 2 days now to create a subscription to a
> SQL Server 2005 database but I haven't had any success. After reading
> all of the documentation and installing everything, the problem seems
> to have something to do with permissions. Here is what works:
> * Created the a merge publication and checked to see that the
> Replication Monitor shows that it works.
> * Checked the directory where the snapshot files are located and they
> exist.
> * Can access the snapshot files from a browser, so I know security is
> setup
> * Tried setting the account for IIS 6.0 on the virtual directory to my
> Windows account which has full admin permissions. Even tried
> anonymous.
> * Set the permission on all of the files and directories where the
> snapshot files are stored.
> * Added my Windows account to the PAL in the publication.
> * Added my Windows account to the SQL Server login accounts
> I then created an empty SQL Server 2005 mobile database locally on my
> PC. Then I accessed it in SQL Server Management Studio.
> Finally, I selected the New Subscription Wizard on the node of my
> mobile database and tried using all kinds of login accounts.
> Where it hangs is when I get to the last screen where it attempts to
> create the subscription. After hanging several seconds on the part
> that says "Synchronizing Data", it comes back with an error message
> that either tells me that the SQL Server does not exist and/or the
> user account does not exist. If I try screwing around with the various
> types of login accounts, it can sometimes come back and say the IIS
> account is not in SQL Server. There are a lot of accounts to setup
> everywhere - publiccations, distributor, IIS, the database. Man, this
> is getting to be one ugly headache. Can someone please give me some
> solid steps on how to create a subscription.
> Much appreciated,
> Johann
>

Cannot Create Subscription

Using RS Standard, SP2, I am prevented from creating a subscription on
reports that I am able to schedule for snapshots. The error message says
"Subscriptions cannot be created because the credentials used to run the
report are not stored, the report is using user-defined parameter values, or
if a linked report, the report is no longer valid." There are no linked
reports involved, and there are both report parameters and query parameters,
but all have supplied values or defaults. (Since a snapshot works fine, it
would seem that criteria for a subscription would be satisfied). This is a
major problem for my users who believe subscription delivery is an essential
feature. Please help!
--
Bob RogersThen the only part of the error message your response didn't cover is the
credentials... They must be stored securely in the database... Go to the
datasource, and you may set the connection stuff to be stored in the
database... Then subscriptions can be made.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> Using RS Standard, SP2, I am prevented from creating a subscription on
> reports that I am able to schedule for snapshots. The error message says
> "Subscriptions cannot be created because the credentials used to run the
> report are not stored, the report is using user-defined parameter values,
> or
> if a linked report, the report is no longer valid." There are no linked
> reports involved, and there are both report parameters and query
> parameters,
> but all have supplied values or defaults. (Since a snapshot works fine,
> it
> would seem that criteria for a subscription would be satisfied). This is
> a
> major problem for my users who believe subscription delivery is an
> essential
> feature. Please help!
> --
> Bob Rogers|||Thanks for your reply. The database credentials were good; the problem
turned out to be user id being included in the template for report footer --
user id is apparently considered a parameter.
--
Bob Rogers
"Wayne Snyder" wrote:
> Then the only part of the error message your response didn't cover is the
> credentials... They must be stored securely in the database... Go to the
> datasource, and you may set the connection stuff to be stored in the
> database... Then subscriptions can be made.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
> news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> > Using RS Standard, SP2, I am prevented from creating a subscription on
> > reports that I am able to schedule for snapshots. The error message says
> > "Subscriptions cannot be created because the credentials used to run the
> > report are not stored, the report is using user-defined parameter values,
> > or
> > if a linked report, the report is no longer valid." There are no linked
> > reports involved, and there are both report parameters and query
> > parameters,
> > but all have supplied values or defaults. (Since a snapshot works fine,
> > it
> > would seem that criteria for a subscription would be satisfied). This is
> > a
> > major problem for my users who believe subscription delivery is an
> > essential
> > feature. Please help!
> > --
> > Bob Rogers
>
>

Cannot create subscriber on MSDE2000

I am very new at SQL replication. I set up a publication and distributor at
our SQL 2000 server. All went fine. Now I am trying to create a laptop
subscriber to use (I think) an anonymous subscription. I setup the laptop
with MSDE 2000 SP3. I now want to create a subscription while connected to
the network. I want to use the Windows Syncronizer to synch the database.
I cannot find out how to create the initial subscription database on the
laptop. When I try to manually configure the Windows Synchronizer, I get an
error "The process could not access database 'MCFIData' on server 'LAPTOP1'.
Database is invalid or cannot be accessed"
Well DUH...I was told that it would be created if it does not exist. Any
help would be appreciated. Thanks.
David
Ignore this. I did not have the SQL Agent running on the laptop with MSDE
2000 SP3. I'm not sure why, but there was no prompt for this option when I
installed MSDE. Also there was no instruction to do so on the documentation
for setting up MSDE to be a subsriber!
David
"David" <dlchase@.lifetimeinc.com> wrote in message
news:elqk$rE%23FHA.1248@.TK2MSFTNGP14.phx.gbl...
>I am very new at SQL replication. I set up a publication and distributor
>at our SQL 2000 server. All went fine. Now I am trying to create a laptop
>subscriber to use (I think) an anonymous subscription. I setup the laptop
>with MSDE 2000 SP3. I now want to create a subscription while connected to
>the network. I want to use the Windows Syncronizer to synch the database.
>I cannot find out how to create the initial subscription database on the
>laptop. When I try to manually configure the Windows Synchronizer, I get
>an error "The process could not access database 'MCFIData' on server
>'LAPTOP1'. Database is invalid or cannot be accessed"
> Well DUH...I was told that it would be created if it does not exist. Any
> help would be appreciated. Thanks.
> David
>

Cannot create SSIS projects

When i create a new SSIS project, the system alert will popup a window to show 'Constructor on type 'Microsoft.DataTransformationService.wizards.ETLProjectInitializer' not found'

I met this kind of questions more than 3 time.

Reinstall VS2005?

How should i do?

It sounds like something in the system dll's did not get included or was removed.

Probably the best thing would be to reinstall business intelligence which is a part of the SQL Server install

Re Installing Visual Studio would do nothing due to the fact that SSIS is not associated with Visual Studio 2005 other then through Business Intelligence.