How To Create A Datasource Which Is Not Shared
Mar 13, 2007Is it possible to create a datasource, which is not at al shared via vs 2005
View 1 Replies
ADVERTISEMENT
Shared Datasource Problem
Mar 10, 2006I have created a few packages which uses shared 2 data sources called source and desitination. When i change the server in the datasource file
manuallyprogramatically, it is not reflecting in all the packages. Ideally all the packages should refer to this shared datasource,but i found out that the server name is hardcoded in each and every package which destroyes the concept of shared data sources in SSIS packages.How ever if i change the server name in the data source from the SSIS environment itself then all packages using the shared datasource are updated.Is there a work around for this apart from changing the server in every package.
Shared Datasource In Different Folder...
Jul 16, 2007Hi all,
Ive tried searching but nothing came up specific to my problem.
I currently have all the reports separated into separate folders, such as Finance, HR etc, and the datasources in a datasources folder at the root level. My problem is that when i upload reports into their appropriate folder, the shared datasource information gets deleted, and i need to re-map it everytime.
Is there anyway to have the specific reports point to specific shared datasource folders on the report server when i upload them?
cheers
Rob.
User Credentials Are Getting Lost When Using Shared Datasource
Jun 6, 2007Hello All,
I have a situation and no idea what is going wrong.
We have many reports stored and view from the report manager. many of these reports internally use a datasource which is shared among others.
Many a times we have realised that the report stops working with the error.
Reporting Services Error
The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Get Online Help
SQL Server Reporting Services
All i have to again do is update the user credentials and it starts working again. but nobody explicitly remove the credentials also. i dont know if it a tools bug or some where i am making a mistake in deploying. i deploy the reports through visual Studio.
Any idea?
/Soni
Use Shared Datasource In Embedded Report Code
May 31, 2007Hi,
I was wondering if there's a way to connect to a shared datasource in the Code section of a report's properties. I want to connect using my shared datasource as defined in my solution and query it to return a value based on user input for a function I need to put there.
Thanks,
Greg
Can We Create Shared Report Parametres?
Apr 16, 2007Hi, all experts here,
Is it possible to create shared report parametres passing among different reports on SQL Server 2005 Reporting Services? If it is possible, and how?
Thanks a lot in advance for your advices. And I am looking forward to hearing from you.
With best regards,
Yours sincerely,
Create Database At Shared Hoster Site
Jul 23, 2005I have an sql script that I ran on my local system using osql. Itcreated all the tables, views, and even inserted sample data into thetables.Now I need to create that same database on a shared hoster site. Onlythe hoster does not allow the running of osql.How can I create my sql server database on my shared hoster site?Can I save and restore my database somehow?Is there a stored procedure I can run which will run the .sql scriptfile?thanks,-Steve
View 4 Replies View RelatedPermissions Needed To Create A Shared Schedule?
Mar 10, 2008
I am setting up a role to allow certain users to create and maintain Shared Schedules in SSRS 2005. The tasks I have authorized are:
View reports
View folders
Manage all subscriptions
View data sources
Consume reports
What else do I need to grant? Right now the user cannot see the Site Settings link in order to get the the manage schedules.
Thanks,
Phill
Cannot Create A Datasource Items
Jun 8, 2007I'm trying to use WSS3 & RS 2005 as Integration Mode.
But i cannot create a data source item on sharepoint site library.
If i go to Central Administration > Configure Reporting Services Integration,
I can see the settings, thats mean that the Report Server is available ( i think so )
And also i can create dataources on Central Administration Web site (//servername:12500)
But from my production server web site ( //servername/ ), i cannot create those items.
I received the message
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Can somebody help me to fix that strange behavior.
Thanks.
Cannot Create A Connection To The Datasource 'DataSource1'
Jan 23, 2007Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message, Its very strange it seems that its trying to generate or create a datasource.
Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
----------------------------
No se puede crear una conexión al origen de datos 'dataSource1'.
----------------------------
Error al procesar el informe.
SSRS Cannot Create A Connection To Datasource Error
Sep 26, 2007Hai All..
I have develop any report in reporting services on server Development. i deploy my report to server production.
i have connection to cube as data source. if open report manager in server production and open the report, its succesfully. the report is open. but if i open report manager in server development show error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'PNL'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine
i use windows authentication in my pnl datasource.
thanks
Yudhi
Missing Permission To Create Datasource, New Folder, Add Security..etc
Jun 20, 2007I have windows 2003 reporting services 2005 that has been working fine. Now all of a sudden when I go to http://localhost/reports I am unable to assign security to folders(the link is hidden) the New data source button is hidden, the new folder button is hidden, upload folder and report builder are also hidden. I am logged in as aministrator.
Also when I connect to reporting services through SQL Mgmt Studio I have the same issue, there are no options for permissions only a general option.
I'm sure it's a permissions issue but what do i do to resolve?
Thx
How To Create Cascading Parameters In A Report With Cube As Datasource
Mar 11, 2008
I'm trying to create report with datasource as a cube. I'm able to connect to datasource to pull data with a single parameter. But, I'm unable to succeed in creating a cascading parameter.
The following scenario:
I have a dimension "Period" as Paremeter.
The Period dimension is cascaded to year- quarter- month.
So, I would like to create a cascading parameter for period as year - quarter - month.
Please let me know, how to acheive this.
thanks,
Naveen.
Analysis :: Possible To Create Multiple Data Source View Having Same Datasource?
Jul 27, 20151. As per my current development SQL Sever Analysis Database consists of two Cube (Cube A and Cube B). Cube A and Cube B share the same data source view (DSV1). The source for both these cubes has the same data source (DS1).
2. As per the requirement I need to create third Cube i.e. Cube C. Is it possible to create a second Data Source View (DSV2). The Source of second Data Source View (DSV2) will be the same data source(DS1).
I am thinking to create second Data Source View (DSV2) for Cube C because existing layout of the DSV1 has become complex. I wanted to know the pros and cons of creating a multiple data source view with same data source
Batch Script To Create ODBC And Update Registry Datasource Key - Help!
Feb 21, 2008
I have create a batch file, that creates an ODBC then updates the application datasource key in the registry to the new system dsn name.
The problem is that the new DSN doesn't work when i try and connect the application...but if i had manually created the odbc source the app connects as expected... i have checked the registry and there is no difference between the two dsns created...but the application throws IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified after i have also changed the applications registry key to point to the new database.
Now the interesting things to note are that when i re-create the odbc to the old server and database (sql 2000) by batch file it works fine. The new ODBC is linking to a sql 2005 database, but it is still using the 2000 drivers and when i manually created it, it worked also.
Another interesting thing is that if i go into the odbc dsn and click configure, go through and test the connection it works fine... after i close this i then retry the application and it opens correctly...
I need this to be automated with no manual intervention, as this will be added to a large group of users login scripts!
Any help greatly appreciated.
My batch file code is as below:
ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=RMS Live 2005 | SERVER=d-db99sql2005| Trusted_Connection=Yes | Database=RMS-Livedb"
Trouble Using ADOX To Create Linked Tables In Jet Database From An ODBC Datasource
Jun 5, 2007Hai,
I am using ADOX to create linked tables in a jet database from an ODBC datasource.
The tables in the ODBC data source does not have a primary key.
so I am only able to create read only linked tables.But I want to update the records also.
I tried adding a primary key column to the linked table while creating the link.
but I am getting an error while adding the table to the catalog.
The error message is "Invalid Argument".
I use the following code for creating the linked table
Sub CreateLinkedTable(ByVal strTargetDB As String, ByVal strProviderString As String, ByVal strSourceTbl As String, ByVal strLinkTblName As String)
Dim catDB As ADOX.Catalog
Dim tblLink As ADOX._Table
Dim ADOConnection As New ADODB.Connection
ADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strTargetDB & ";User Id=admin;Password=;")
catDB = New ADOX.Catalog
catDB.ActiveConnection = ADOConnection
tblLink = New ADOX.Table
With tblLink
' Name the new Table and set its ParentCatalog property
' to the open Catalog to allow access to the Properties
' collection.
.Name = strLinkTblName
.ParentCatalog = catDB
' Set the properties to create the link.
Dim adoxPro As ADOX.Property
adoxPro = .Properties("Jet OLEDB:Create Link")
adoxPro.Value = True
adoxPro = .Properties("Jet OLEDB:Link Provider String")
adoxPro.Value = strProviderString
adoxPro = .Properties("Jet OLEDB:Remote Table Name")
adoxPro.Value = strSourceTbl
End With
'Adding primary key,
'***** the source column name is "Code" ******
tblLink.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "Code")
'Append the table to the Tables collection.
'******The exception occurs on the following line***********
catDB.Tables.Append(tblLink)
'Append the primary index to table.
catDB = Nothing
End Sub
If I avoid the line for adding the primary key,everything works fine,but the table ctreated is readonly.
Thanks in advance
Sudeep T S
How To Create A Datasource Which Connection Type Is SQL Server Anlysis Service In Rss Script?
Oct 20, 2005I am making a rss script to deploy the reports and datasources.
View 2 Replies View RelatedHow To Use A Stored Procedure With Parameters To Create The Datasource View For Report Model Builder
Mar 12, 2007I have a stored procedure that takes a date range and returns all the sales in that date range. I'm trying to create the report model for ad-hoc reporting. When I go to create the dataset view, it only lets me select tables or views.... how do I get around this?
View 2 Replies View RelatedShared Drive
May 11, 2000Hi,
I have a shared drive mapped to the h: drive letter on my sql server and I want to create new databases on that drive. Is this at all
possible?
I try it and I couldn't see h: even if I typed it in.
Thanks
Shared Hosting
Feb 16, 2008Hello
Maybe someone can suggest me some software which can be used for SQL 2005 shared hosting?
With database size limit, user number restriction and other features.
Thank you for information in advance
Cannot See Shared Datasources
Apr 9, 2008I am new to reporting services, working with RS2000. Roles and security have previously been set up.
Shared Datasources have been created. How is access granted to shared datasources?
Some users have access but we haven't been able to create new users with access to the shared datasources.
Thanks
Using Shared Variables.
Mar 6, 2007Hi,
I am trying to use shared variables in the emebedded code of a report. But
when i assign a value to the shared variable in the detail level and access
the same from footer it shows different value (0).
I declared an integer variable as a shared variable. And changed its value
in the detail level. Then tried to access its value in the table footer.
Public Shared testVal As Integer
Function testValFunc()
testVale = 25
End Function
In detail level i call Code.testValFunc()
In footer -> Code.testValFunc() gives 0
Any Idea??? Is it because the header/footer is computed first and then the detail?
-
HelpSeeker
Dedicaced Or Shared Connection ?
Jul 11, 2006Exit it in sqlserver notion of shared connection or dedicaced connection like there is exist in oracle ?
Exit it a part of memory (like PGA in oracle) who exist just for the connections ?
Else what are constitued the memory in sqlserver ?
Thanks
Shared SCSI Setup...
Jan 12, 2004Ok, got an assignment from my boss.. Need shared storage for a 2 node cluster, with main focus on MSSQL DB Failover. We won't be storing alot of data, speed it not really an issue, just availability..
As far as I know I need 2 SCSI cards, 1 for each node. Node1 has to have ID7 and Node2 ID6 (for example)
this is it.. what's next? what's the best way to configure all this? Do I need a special box for all hard drives to be with certain controller?
I was thinking to link up like this
terminator
|
Node1
|
|
Disk
|
|
Node2
|
terminator
But I wanted to run some sort of RAID on disk, mirroring is fine.. Anyone can suggest me what parts I should get for this setup? my servers don't have 64bit PCI too
Shared Dimensions - OLAP
Mar 25, 2004Hi,
I have noticed the the cubes that we have here use shared dimensions.
For almost all cubes(5-6) there are at least 4-5 common dimensions.
According to what I have been preached so far, the shared dimensions are so that you can reuse them. That is not what is practised here.
for example.
cube1 has somedim1, dim2_c1, dim3_c1...
cube2 has xyzdim1_c2,xyzdim2_c2,dim3_c2..
dim3_c1 and dim3_c2 are the same dimensions, one for each cube.
I don't know if I am missing something. Shouldn't the use the same dimensions? Could there be any reason for this.
pls. advice.
TIA
Shared Connexion Between Package
Apr 21, 2008Hello,
Here's my problem :
I have several packages, one parents and several childs.
I want to define just one connexion for all theses packages, so I used a Data source. But I had several problem with that object.
So I'm looking for the best way to define one working database connexion for all my packages.
Can someone help me ?
Thanks in advance.
Using Sql Server 2005 In Shared Pc.
Apr 5, 2007HI,
currently two people(with different username and password) are using a shared workstation, where in the sql server is installed. so i just wanted to know that whether two people could use the sql server at the same time. please note that the two people have different username and password to enter to log in.
Thanks,
Nitin
Shared Server Issue?
Jul 20, 2005We've been running a database on a shared server. The traffic on oursite has been picking up steadily and it seems as though we're runninginto sporadic downtime on the database. Sometimes when we do largedata imports, the transaction log fills up and the schema somehowfails to truncate it when asked to back it up. So we run the explicittruncate statement and that usually seems to fix the problem. A fewdays ago a single stored procedure started to block, but inexplicablyonly when called by our .NET server. When called by hand fromEnterprise Manager, it executed fine. I was at my wits end when Ijust recreated it with the same exact code and it magically startedworking again. What gives? Is this at all indicative of a shareddatabase, or are these known SQL Server issues?
View 4 Replies View RelatedAcessing SQL Server Over The Web With Shared IP
Jul 20, 2005I am new to setting up SQL Server and would greatly appreciate ifsomeone can help me out with this issue:I have successfully set up SQL Server but want to be able for clientsof mine to be able to connect to it via the web through enterprisemanager. I have tried everything I could think of to get it to work. Imade sure the correct ports where open in the firewall (1433,1434).Everytime I try to connecting using the IP of the box that the SQLServer resides I get SQL Server does not exist or access denied. Iverified that the login credentials being used for the database I amtrying to correct to are correct. Still the same error message.How I would like to set it up would be to create a subdomain on thebox and point it to SQL Server so that is what would be entered whenregistering the group in enterprise manager.I am currently running all my sites through vhost on a single IP usingIIS 2003. SQL Server is installed on the box where all of the sitesare being served up.Is it impossible to set-up SQL Server to allow connections over theweb when using a Shared IP?I have been researching this for over a week now and hope someone outthere can help me.Thanks in advance!!
View 3 Replies View RelatedSQL CE Private V. Shared Deployment
Feb 2, 2007I have a couple of questions on the nature of shared and private deployment of SQL Server CE 2005 on mobile devices:
1. I've read that with a shared install, SQL Server 2005 Compact Edition files are automatically updated and serviced by Microsoft Update. I take it that this only applies to installations on desktop computers -- if you're installing on mobile devices, there IS no automatic update. Right?
2. I've also read that in order to do a shared install of SQL Server 2005 CE, the user must have administrative rights. How does this apply to installs on a mobile device? There is no such thing as an administrative user on a mobile device. However, mobile devices CAN require different levels of privilege to install certain programs -- do you need something like an application signed for privileged execution (via a M2M certificate) in order to do a shared install of SQL Server 2005 CE on a mobile device?
Or is the shared versus private deployment only an issue when deploying to a desktop?
Larry
Displaying Shared Schedule Only
Sep 25, 2007
Hi,
Is there a way to display only the shared schedule option in the subscription page? in other words, can the manual scheduling be hidden?
Thank you.
Shared Data Source
Dec 19, 2006I experimented a strange behavior using connections for data source inside packages in vss 2005.
Suppose we have a tab1 in a develpment source db and in a test source db:
tab1 dev db contains 100 records
tab 2 test db contains 200 records
I start developing a package using an 'ole db data source' task inside a data flow. When I change the data source from dev to test, strange thinks happens.
The 'ole db source task' retrieve only 197 records ... but if I open the connection inside the connection manager pane and only after i click on the 'test connection' button tI get 200 records.
The source db is a sql 2000 db server and I use ole db provider for sql server.
Cosimo
SSRS Shared Schedule
Oct 10, 2007
Hi All,
I need a report to execute every 5 minutes on every week day and I am trying to do this using a shared schedule.
I had looked all the options available with Shared Schedule and looks like there is no way to do this.
Please let me know if you have a work around.
Thanks,
Prakash.P