When I try to view my report manager from the computer that SSRS is installed on, I cannot do any administration on it. How can I get this back?
Here's some more info: I browse to http://localhost/reports on the machine and it only shows links for "Home", "My Subscriptions" and "Help". there are no options to add a new folder, set up security on the root folder or any admin functions.
I looked into the HELP and it wasn't any...
Hi,Consider this (light example):SELECT [template].[id], [template].[navn], [tvalues].[id]FROM template LEFT JOIN Tvalues ON [tvalues].[templateid]=[template].[id]This returns ok. But I have a clause on the Tvalues like this:WHERE [tvalues].[nr]=1;Now I dont get what I want anymore? What I mean here is:"return all records from Template and the corresponding values in TValues.If no corresponding values can be found or those where TValues.nr<>1 thenreturn NULL".Erhm...`Hope u get my meaning.../Pip
View 3 Replies View RelatedThere I was merrily working away on my SSIS package, when one of our lovely network people completely wiped the drive my SQL Server database was sitting on. I was a bit miffed.
I was even more miffed when I found out after restoring the database that the package I was editing would no longer connect to it. I've removed and recreated all my datasources and connection managers and no luck.
I get a number of errors -
When trying to execute a simple task to take populate a table in my SQL Server database from a remote source I get:
[ODD - PMP10 in ORBIT STAGING [652]] Error: SSIS Error Code
Code SnippetDTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ORBIT STAGING" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
I can however, connect to the database in design mode, using the same connection parameters - I can create tables too, so access rights look ok.
When trying to run a for each container that uses an ADO Connection, I get:
Code SnippetError 1 Error loading Orbit Extract.dtsx: The connection "ORBIT_STAGING - ADO.NET" is not found. This error is thrown by Connections collection when the specific connection element is not found. D:DevORBITExtractOrbit Extract.dtsx
Well, the connection does exist, so it must be a corrupt internal pointer or something...
If I double click on the errors, It takes me to the top of the XML file, and I'm loath to mess with this directly, as I don't know what is what here...
Anyone know of a way to sort this out?
Hi,
I did something bad (I don't recall what it was) and I can no longer log into Reporting Services. I wish I could list everything I've tried but I've been at it so long I don't remember. And I've been through the ringer of error messages.
Is there a way I can completely reset and/or restart all the settings from the original install - without doing a new install? I am afraid I am going to mess up SSAS, SSMS, SSIS and something else.
Thank you for the help.
-Gumbatman
I have this #@!% installed on my machine and when it failed I made the
major error of following some telephone instructions from their
"help-less" support desk - - - well their $#@% products now runs again
(oh whoopie) -but- nothing else related to sql server will work.
This includes:
Visual Developer 2005 Express - Database Explorer
SQL Server Configuration Manager, Surface Area Configuration, etc., etc. (not found)
I tried to re-install SQL Server -but- the install fails, fails, fails...
The failures are always with a corrupt msi file that has just been downloaded / expanded - yet fails???
I have registered and sent error reports -but- I still don't have a functional sql server version running and available.
I do have "their" version of SQL Server running again - this time it is named my-machine-nameGOFIGURE
Like an idiot I deleted folders and un-installed sql server (as per 'their' instructions)
NEVER again - if I ever get things back to "normal"
WHAT should I do - I would 'like' to continue to run their software -but- NOT at the expense of everything else.
If I have to uninstall anything - please list - thanks :)
Thanks,
Paul
i changed a float data type to a decimal and have lost accurate details, is there a way of rolling back to what it was before
View 1 Replies View RelatedUsing SQL Server 2000 and moving to a new computer. We did a full backup ofthe existing database to tape, brought up the new computer with a cleaninstall using the same server name and IP address, and did a full restore.Not only were some permissions messed up, but Crystal Reports 10 and someAccess Data Projects refused to run. I finally discovered while running anSP_WHO that the individual database names that we'd created (meaning not'master' and the other standard tables) had several dozen blanks appendedonto the end of them. Looking at dbnames in the SP_WHO made it clear thatthis had happened, and once I knew what I was looking for it was apparent inEnterprise Manager as well when I'd select a database name in the left pane.Interestingly, VB6 applications have no trouble connecting to these tableswithout modification of the connection string. Every single CR10 report sofar has had to have it's tables relinked, and this has broken some othercode that looks at dbnames.1: How could something like this happen?2: How is it best fixed?Thanks!David
View 3 Replies View RelatedHello
I need to import a unicode text file with a DTS. The textfile needs to be imported width fixed column width settings as there are no field delimeters.
The data in the file is messed up (some columns are concatenated) when opened in Notepad.
The data looks fine when opened in Wordpad and also all fields are nicely delimeted but then I end up with unicode characters which are not supported in Wordpad.
Is there anyway around this?
Many thanks in advance!
Best regards,
Worf
Hello:
We are running an application on mssql 6.5, sp 4.
As the data for the application is growing by leaps and bounds, we were shortly going to run out of disk space on one and decided to move production to a new, larger box.
I took a full backup of the current production database nad loaded it onto the new server with no problems except one.
When users tried to log in, there were problems. Apparently the passwords for users were switched with other users or somehow the sysusers data got reversed. THe logins, or the data from msyslogins, looked fine.
I don't understand how a full backup and then a restore would have any effect on the sysusers data.
Has any one experienced this before? Other than bcp out the data from sysusers and bcp'ing the data after the restore, is there any thing else I can do?
Does any one have a script tp offload sysusers data?
Any help which can be provided would be appreciated. THanks.
David Spaisman
I installed the evaluation version of SQL Server 2005 and now my DSL connection on Windows XP is all fouled up; I'm using Server 2003 at the moment. Will uninstalling it get rid of the problem? First Oracle eats my DSL connection, now SQL wants a piece! :eek:
View 4 Replies View RelatedRecently moved a couple of dbs from SQL 2000 -> SQL 2005 (different machine). Just restored the dbs on the new server from a full backup of the old one. Everything is fine but...
Some queries are returning out-of-order results (for records added since the migration). I tracked this down to the indexes. I completely rebuilt and reorganized the indexes (online) through the manager interface. This helped provide correct ordering for existing records, but new records added since the re index are still out-of-order.
Looking for a way to permanently fix the indexes so I don't have to constantly rebuild them.
Thanks.
I am using SQL7 Query Analyzer. A simple select * from myMLSview andthen I save results as a .csv file has the commas messed up in quite afew places. The data is messed up before I save it to the .csv file. Sothere are blank spaces being added here and there causing them to readas 'add comma' when saving to .csv format. Even the column data ismessed up... example: ,photo_mod_time,photo_mo,d_date, should read,photo_mod_time,photo_mod_date,I have a view on a remote MS-SQL7 Server, the view has about 200columns and the data returned from the my querys can be from 10 to 25MBin size. Connection is via Roadrunner/cable. Should I use anothermethod, maybe command line? Any suggestions?
View 3 Replies View RelatedI have (had!) SQL Server 2005 Express and Visual Studio Web Express
2005 (still do) installed but need to write some Reporting Services
reports. I have now bought a Sql Server 2005 Developer license (£40 version)
and have installed it. However I couldn't find any new installation in
my program files so i uninstalled it and the express
version and tried to reinstall the Developer edition but it
kept stopping with all the options greyed out saying there's nothing
to install. So i managed to install as an instance, can't install the 2nd disc though ?? Am i doing something wrong here ? how can i satrt again ??
hopefully
steve
Hi,
I am using expressions for the textboxes in the Table control Header, because the header names should be displayed in both English as well as in Japanese based on the language selection.The report works fine and all the render formatts except CSV are working fine.when i export this report to CSV, the header names are not coming in the first row of CSV , but some other textbox names (eg textbox 34..) are being displayed on the first row of CSV.From second row onwards, i am getting the header names seperated by comma and the data is being displayed.This header names are being repeated for all the rows in the CSV along with the data.Please give me a solution regarding this.
I tried by setting Data Element as "NO" from "Auto".I could stop the header names being repeated from second row in CSV, but i couldnot get the names in the first row of CSV.
I need to have all the header names as first row in csv and from the second row, i need data.
Hey Everyone,
I have a Data-Flow task embedded in a Sequence Container (does not fail component on error) on the Control Flow panel of the SSIS designer. This data flow task contains a connection to a Flat File Source -> A Data Transformation -> Into an OLE Db Destination.
The problem is that the Flat File isn't always delimited properly -> the client cannot be relied on to do this.
My question is when the delimiters are messed up, how can I capture the offending error row(s) from the Flat File Source?
What I've tried:
1) Set every column in the source flat file on error to: Redirect Row
2) Added a Script Transformation to pull the description and the record id out of the offending row
3) Added an Error file flat file destination to the end of the flow.
The package always fails on the Flat File Source and never Redirects the offending Row to the error output - I never see my onError Script Transformation go Green, Red, or Yellow - SSIS doesn't let it get there.
I'm really new to SSIS so sorry if this is a super basic question.
Here is the Error Text:
[Source - InventTable_csv [1]] Error: The column delimiter for column "RECID" was not found.
[Source - InventTable_csv [1]] Error: An error occurred while processing file "C:------InventTable.csv" on data row 15228.
[DTS.Pipeline] Error: The PrimeOutput method on component "Source - InventTable_csv" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.
I do have the MaxErrorCount set to 1 on the Data Flow Task but still think I should see my script task execute and a log entry be generated.
Any Ideas?
Matt
Hi... I'm reading the MS Press 70-442 Self-Paced Training kit, and I'm having problems with this example.
I'd like help getting it to work correctly, or understand why it is isn't working the way I planned.
On page 67, the lab is about the APPLY operator (CROSS APPLY and OUTER APPLY). I first have to input a sample table-valued function into the AdventureWorks database:
Code Block
CREATE FUNCTION fnGetAvgCost(@ProdID int)
RETURNS @RetTable TABLE (AvgCost money)
AS
BEGIN
WITH Product(stdcost)
AS
(
SELECT avg(standardcost) as AvgCost
FROM Production.ProductCostHistory
WHERE ProductID = @ProdID
)
INSERT INTO @RetTable
SELECT * FROM Product
RETURN
END
and then run a sample T-SQL statement
Code Block
SELECT p.Name, p.ProductNumber,
Convert(varchar, cost.AvgCost,1) AS 'Average Cost'
FROM Production.Product p
CROSS APPLY fnGetAvgCost(p.ProductID) AS cost
WHERE cost.AvgCost IS NOT NULL
ORDER BY cost.AvgCost desc
My problem is with the WHERE clause... According to page 56, CROSS APPLY returns only rows from the outer table that produces a result set, so why do I need to explicitly filter NULL values?
When I remove the WHERE clause, the query retrieves lots of NULL AvgCost values.
Again, according to page 56, it is the OUTER APPLY that returns all rows that return a result set and will include NULL values in the columns that are returned from the table-valued function.
So, in short, I don't see the difference between CROSS APPLY and OUTER APPLY, using this example, when I remove the WHERE clause?
(Please refrain from introducing another example into this question.)
I use from sql server 2008. and c#
what is the best connectionstring?
I don't know if i use Persist Security Info and Integrated Security or not?
And if yes then their value must be true or false?
Hello there I have trying to figure out for days how to enable FullTrust for my Reporting Services security extension.
View 9 Replies View Related
Hi,
I have posted this issue for a week, haven't got any reply yet, I posted it again and desperately need your help.
The article http://msdn2.microsoft.com/en-us/library/ms365343.aspx says:
Model Item Security can be set for differnt security filters, but when I use SQL Server Management Studio to set Model Item Security, it seems "Permissions" property surpass "Model Item Security" property. -- My report server is using Custom Authentication.
For example, in "Permissions" property of the model, if I checked "Use these roles for each group or user account" without setting any user or group, no matter what users I added to "Model Item Security" with "Secure individual model items independently for this model" checked, NO one user can see the model on report manager and report builder;
in above situation, if I added "user1" and gave role such as "Browser" role to "user1" in "Permissions" property, if I checked "Secure individual model items independently for this model" in "Model Item Security" property, even I did NOT grant "user1" to root model and any entities under the model, the "user1" is able to access the model and all entities in report builder.
My question is on the same report model, how to set "AdminFilter" (empty security filter) for administrator permissions and set "GeneralFilter" (filtered on UserID) for general user based on their UserID?
The article also says:
"Security filters are always applied, even for users who have Content Manager or Administrator permissions to the model. To allow administrators or other users to see all rows of an entity on which row-level security is defined, you can create an empty security filter (which always returns True) and then use the filter to grant those users access to all the rows."
So I defined 2 filters "GeneralFilter" and "AdminFilter" for "Staff" entity for my report model "SSRSModel", I expect after I deployed the report model, the administrator users use report builder to build reports with all rows available, and the non-admin users can only see rows based on their UserID.
I can only get one result at a time but not both:
either the rows are filtered or not filtered at all, no matter how I set the "SecurityFilter" for the entity: I tried setting both "AdminFilter" and "GeneralFilter" for SecurityFilter at the same time, combination of "DefaultSecurityFilter" and "SecurityFilter", or one at a time.
Your help is highly appreciated!
Desperate developer
hi i want to know what is the differance between
Persist Security Info=False;Integrated Security=Yes;
Is there any possibility to schedule SQL job execution as Windows Security Group? I need to run powershell script through SQL job with one of this group member's permissions.Â
View 4 Replies View RelatedI have Sql Server Express installed on Vista (service pack 2)
I have Visual Studio 2005 with an application that I'm trying to access it with within a WCF service.
The login ID of the service is added to the database.
The database has remote access turned on.
The ID is granted access to all databases within the server.
The thread is being set with WindowsProvider and the services set their thread to WindowsProvider.
The dataserver is set with using Windows Authentication for security.
When I open my connection to the database, though, it reports the typically useless message that the connection is not allowed and that the server may not allow remote connections.
How to I get past this? I've done everything right.
I want to use an Active Directory security group that is a Distribution List for a new role assignment for an existing report. Can someone tell me if this is possible? I get an error each time I try:
The user or group name <DLName> is not recognized. (rsUnknownUserName)"
Is there anybody out there with a MS SQL 2K Security Baseline orSecurity Checklist. Where can I get one????Thanks in advanceDavid
View 1 Replies View Related
Hi;
I am looking for a way to log all security related events for SQL in Windows Security Log. I am trying to use SCOM for monitoring SQL and I am looking at ways to generate alerts in my SCOM Console for specific events in SQL e.g. A table is deleted, user is modified, deleted, etc. Is this possible and if yes how do I achieve the same?
Rgds;
In an environment where there are many initaitors speaking to a central target with frowarders in between, from what i can understand this best policy is to disable encryption on the endpoints, since dialog encryption will be enforced this is all that is really required, is this correct.
If the endpoints used encryption the message would need to be encrypted and decrypted at each forwarder resulting in slower perfromance, where as dialog encryption would only encrypt at the sender and decrypt at the target, so is this the best way to go?
Secondly is it best practice to open a dialog initally and send messages over this dialog for years never ending the conversation? This way the services only have to authenticate eachother once, if there are no reboots etc that is of course.
I would think performance wise sending each message and ending the conversation each time is a much greater overhead ? So would it be best practice to keep dialogs open and keep sending messages ?
Initally when i was learning service broker i thought that one must send a message and end the dialog until the next message, but i think the other way is the best option ?
Is this correct ?
Thanx
Hi
I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use? Where do I configure the type of security being used? What is the difference between transport security Vs dialogue security - Full security model?
Thanks
Hi:
Can anybody tell me the advantage and disadvantage to use NT security for SQL Server 7.0? For a corporation with 400 users, what is your recommendation for the SQL Server security management. Thanks.
Joan
What's the better security to use? Currently I'm always registering using the Windows authentication. When I'm trying to register using SQL authentication I always get "Login failed for user 'sa'" error....
View 1 Replies View RelatedI have setup a linked server on the same computer but different instances of sql. When I call the sprocs an error occurs... The message is...
The OLE DB provider "SQLNCLI" for linked server LINKEDSQL does not contain the table ""product"."dbo"."AccountTable". The table either does not exist or the current user does not have persmissions on that table.
I've checked the table "AccountTable" and it does exist. The database exist also which is "product". I also configure the linked server's RPC to "true" and timeout to "200". The linked server is also configured to use a single username and password which exist on the instance of sql that the linked server is connecting. Also, I enabled the instances of sql to allow remote connections and use mixed authentications.
The mode of access is that different client pc will call a method created with .NET, which in turn, call the sprocs on the linked server. Should I add all the client pc that will be calling the method? Why I'm getting this error? Help please? Thanks
I would like to trap all of the hosts connecting to one of my sql servers and then determine if one of the hosts is not on my list of approved hosts. If the host is not approved, I would process an alert.
I have written a stored proc that queries the sysprocesses table and then raises the alert. The problem is that sysprocesses only includes entries for the length of the connection. Someone could access the server quickly in between my proc running and I would not capture it. I thought about putting a trigger on sysprocesses to write to a history table but I do not like to put triggers in the master db.
Has anyone tackled this issue before or know where I could get a history of all connections to the sql server?
We have a 3rd Party system running on SQL Server that has presented us with a security problem.
All logins are handled by the application but the end result is each user has an easily identifiable login and password on the sql server box itself.
At a basic level there is nothing to stop a user linking through Microsoft Access and deleting table contents. We could live with that as Access knowledge is very limited.
Unfortunately a couple of developers now have Enterprise Manager and Query Analyzer installed on their workstations and they have already begun poking their noses where they are not welcome. The possiblity of data edits without an audit trail is now much higher.
Is there something I can do to block access?
I have found a stored procedure sp_MSSQLDMO70 in the master database which when execute is denied the user cannot log on through EM but is there anything similar for QA?
Help, they are getting a bit too eager to take my job!!
Andy
when u run a job using sql agent, say like a backup job, which security account does SQL use to run the job ?
also how does it differ if you execute the same job from
the command prompt or query analyzer ?
Thanks