Hello,
There's information on my Internal SharePoint DataBase that I want to access. How can I do this? Could you help me or at least point me in the right direction.
The information I am requesting is just text.
Thank you,
Mark
I have a sharepoint on a windows internal database server (some version of sql express 2005). When I run the app, it says that I need SQL server reporting services 2005. I dont think that this component is bundled with "windows internal database server". Is there anyway I can download this component or otherwise make this work?
Seems a bit silly that they would make a tool requiring a component that doesnt need to be installed for sharepoint to run.
I am developing a web site with asp.net 2.0 and c#, using Visual Studio 2005 and Microsoft SQL Server 2005 ( I am still learning about these technologies and languages ).
I transferred my web site files to a new computer.
I created a empty SQL database called "SiteData.mdf", I stopped the SQL server and then I replaced this database with a previous one with the same name and already populated with data.
I used this maneuver in order to avoid having to insert all data again.
The web site works fine when running inside Visual Studio, however when I try to run it in its published format it gives this error message:
Server Error in '/MA' Application.
Cannot open database "SiteData" requested by the login. The login failed.Login failed for user 'CENTAURUSASPNET'.
I also observed that inside the SQL Server Management Studio, in the database properties, it shows "ETHERASPNET" as User or Roles ( however "ETHERASPNET" was created using the old computer's name [ or should I say domain ? ]) but the permissions list correctly displays the new name "CENTAURUSASPNET".
I think that I, probably, should create a new user using the name "CENTAURUSASPNET" because it would use the name of the new computer ( or domain ) and then I should delete the old user name. Actually I tried to do that but I get the message "An object named ‘CENTAURUSASPNET' cannot be found".
So,
1) What should I do to get the database being connected with the published web site ( note: I am publishing it in my own computer for awhile ) ?
2) How do I create the new user name "CENTAURUSASPNET" ?
3) I also would like to know why the name of the database in the Server Explorer panel of VS appears as "centaurus.SiteData.dbo" -while- inside the Object Explorer panel of the SQL Server Management Studio it appears simply as "SiteData" ?
I am developing a web site with asp.net 2.0 and c#, using Visual Studio 2005 and Microsoft SQL Server 2005 ( I am still learning about these technologies and languages ).
I transferred my web site files to a new computer.
I created a empty SQL database called “SiteData.mdf�, I stopped the SQL server and then I replaced this database with a previous one with the same name and already populated with data.
I used this maneuver in order to avoid having to insert all data again.
The web site works fine when running inside Visual Studio, however when I try to run it in its published format it gives this error message:
~~~~~~~~~~
Server Error in '/MA' Application.
Cannot open database "SiteData" requested by the login. The login failed.
Login failed for user 'CENTAURUSASPNET'.
~~~~~~~~~~~
I also observed that inside the SQL Server Management Studio, in the database properties, it shows “ETHERASPNET� as User or Roles ( however “ETHERASPNET� was created using the old computer’s name [ or should I say domain ? ]) but the permissions list correctly displays the new name “CENTAURUSASPNET�.
I think that I, probably, should create a new user using the name “CENTAURUSASPNET� because it would use the name of the new computer ( or domain ) and then I should delete the old user name. Actually I tried to do that but I get the message “An object named ‘CENTAURUSASPNET’ cannot be found�.
So,
1) What should I do to get the database being connected with the published web site ( note: I am publishing it in my own computer for awhile ) ?
2) How do I create the new user name “CENTAURUSASPNET� ?
3) I also would like to know why the name of the database in the Server Explorer panel of VS appears as “centaurus.SiteData.dbo� –while- inside the Object Explorer panel of the SQL Server Management Studio it appears simply as “SiteData� ?
When i try to connected to existing configuration database it's only shows NT AUTHORITYNETWORK SERVICE as my login user for database access , when i type another user , error message " you must specifay the same user account as your farm server you wish to join " how i can change it.
please help me how i can change the configuration user and password for my singel farm server
Thanks , i fixed it ??
I am looking for sql code/approach to export a text file and 2 excel works sheets(from an excel workbook) in a folder, to 3 different tables in sql server, perform data scrubbing and then export the data from all 3 tables to 3 different excel sheets and post them in 3 different web parts in a share point site.
Mainly sql code(or any code that i can integrate with SQL Server) to post files to different web parts in a share point site is what i am looking for.
Any sort of pointers/suggestions would be really helpful.
Thanks & Regards,
I Installed SQL Reporting services 2012 service with sharepoint 2013 ... and started it with success..I followed the microsoft's procedure.. URL....After , I have not encountered any problems when I created the application <--- 3 databases created in my SQLSERVER instance//The problem occured when I tried to click on my ssrs application_name --> system settings...ERROR 500 Correlation ID: f6c5f49b-6ab0-4009-6f31-fd019ddc3ecc
This what I read in the log of sharepoint -->
01/14/2013 12:18:36.22    w3wp.exe (0x0BEC)                         0x05D8   SharePoint Foundation      Â
    Monitoring                      nasq   Medium     Entering monitored scope (Request
(GET:http://vwaisql201202:22628/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=5abbbf0d-e8dd-4e8e-93d6-eddc77225a9f)). Parent No  Â
[code]....
I need add an report of type "Power View" in Web Part of Site of Sharepoint.What is category chose in Web Parts to add an report of type Power View ?My objective is create an tree menu with links to specific sites (created for me) that have web parts with "Power View".
View 1 Replies View RelatedMy site crashed, so I had to rebuild the Project Site.
I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server).
I then reran SharePoint products and technologies configuration wizard to setup the site.
Configured the Project Service and attached to the existing dB's.
Previously, I used the url http://servername.domain.forest/PWA/default.aspx .
Now when I attempt the use the same URL, I get the following error:
"An unexpected error has occurred"
I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?
I setup PowerPivot (PP) for SharePoint and activate it on few site collections in production environment; I upload a PP workbooks in a library, manage the data refresh schedules, run the data refresh for an external SQL databases, etc. Everything works fine for several days. One day we decide the move one of the site collections (X) from its current content database to its own (new) content db. The way we did it is that we took the site collection backup in production, restored it in test environment (in its own content db; we deleted the old site collection in test first before restoring), checked everything including PP data refreshes etc.; all worked fine.Then we did the same thing in production - we deleted the old site collection X, restored the site collection from the same backup file that we used in test environment, everything works fine EXCEPT the PowerPivot refreshes!! :-(
I am getting these errors: When I click on the workbook, it gives this error "An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: PowerPivot Data".When I click OK on error dialogbox, it opens the workbook fine but no slicers/refreshes work now. When I go back to the library and click on "Manage PowerPivot Data Refresh" to open the refresh history/schedule page, it gives this generic but scary error: "An unexpected error has occurred. Troubleshoot issues with Microsoft SharePoint Foundation." ULSViewer or Event viewer is not showing anything related to this error!Strange thing is that PP refresh works fine in Test environment, as well as on other site collections in production that we didn't touch (which tells me there is nothing wrong with my PP configuration). Did the backup/restore in prd cause anything? Did moving it in its own contentdb cause anything? (But then why it works in test environment?) Is there anything wrong with site collection PP feature.
I'm getting the following error:An error has occurred while establishing a connection
to the server. When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified) Here's the setup: I have a website I've published on my server, but I haven't moved the SQL DB over to the server. For some reason the testing server can't connect with sql express on my computer. I have named pipes, tcp/ip both on, connections string is "Data Source=AMBA-176SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI"When I'm simply testing the site locally in visual studio it can connect just fine.
I don't know how many folks here log into the Microsoft Connect site occasionally to check suggestions and bugs submitted to Microsoft for SQL Server and SSIS (still called DTS on their list). A small pecentage? Almost everyone? (Possibly in this group.) Anyone can vote for feedback they think is important. Theoretically issues with the most votes will get Microsoft's attention first.
Links to a couple new submissions that look interesting:
1. SSMS/QA Style Message Logging for SSIS Execute SQL Tasks
2. ForEach SMO Enumerator Filtering
I vetted these issues in the forum first, so hopefully they're legitimate enough to warrant some useful feedback or even a few high fives!
Hi all,
I have Sql Server 2000 installed in my home and also i have a website that works with Sql Server2000 and .Net FrameWork v1.1 ,now i want to know is it possible to connect from my home SqlServer to Host SqlServer( where my Website resides ) through Enterprise manager or Query Analizer to do some data-manipulation And how?
Thanks in advance.Regards.
I need to install SSIS/SSRS in SSMS. I have connected the SharePoint list view to excel for reporting purpose but due to data size the performances is very slow in excel and now I would like to connect the SharePoint List to SSIS/SSRS
I have windows 8, 64 bit system
I have installed SQL Server Management studio 2012 but I am unable to enable the Integration and Reporting Services
May be I have missed to choose the option during installation.
Hi,
I've read already every thread in this forum regarding this topic with no results.
SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.
The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.
Looking in the log files in RS log directory, there is following stacktrace:
w3wp!processing!1!05/11/2007-10:40:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
I don't see any hint in stack trace, Maybe one of yours.
As it seems, after an iisreset the first rendering always works perfect. HD space is enough.
Any ideas?
Ok,
I am a webdesigner who at the moment does not know SQL (although, I plan on remedying that) so I am developing a page with a DB designer - he is doing the DB work, I am doing the look/feel, but he asked me the following questions, of which I cannot seem to find an answer and the guys who tend our server are useless - so I am hoping someone here can help me. In general what he needs to know is:
"what is the external address (either in domain format or IP) and the equivalent internal address so that we can access the msSQL running on your server. The internal address is needed for the webpages to talk to it, while the external address is needed for development of the pages in visual studio and the database tools." Also, he later sent me an email asking that when I get this info (from someone) that it would be usefull to get a sample string/query to get access to the DB. I am running SQL 2000 and have enterprise manager. Where can I find this information? or how do I figure this out????
Thank you for all the help -- Please let me know if you need any more info.
I am in the process of designing a web application for our application that will be available to the general public.Basically will be used to collect information for a case report. I need to know if there is a way from our internal database driven application to push certain data up to the website that the database may be behind a firewall so I cannot make a direct connection to the external database. I thought I heard about some sort of data sharing protocol. I then will be storing the users entered data in the website database and pulling it from the internal application. So basically I need a secure way of sending and receiving data between a server/client app on a LAN system to the Web site database that could be hosted outside the LAN.
I hope this made sense.
I am currently reviewing what patch levels various instances are at. One that have come across is a Windows Internal Database (WID), version 11.0.2100.0 (SQL Server 2012 RTM), which is being used for WSUS.
I was thinking about bringing this up to SP 2. I had thought that WID was patched as part of the operating system, not with the SQL Server Service Pack installer. But I have been Googling it, and I cannot find any references to say one way or the other how it is serviced. Does WID is upgraded using the standard Service Pack? Or is there some WSUS magic?
I'm getting the following error:
An inconsistency was detected during an internal operation in database 'LocalLab2000'(ID:5) on page (1:19992). Please contact technical support. Reference number 5.
I ran DBCC CHECKDB ('locallab2000') and no error messages came up and still have the same problem.
I ran then dbcc checktable ('part') with DATA_PURITY and no error messager came up and the problem still whenever i select anuthing in that particular table.
Any ideas?
Thank you
I'm getting the following error:
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database 'LocalLab2000'(ID:5) on page (1:19992). Please contact technical support. Reference number 5.
I ran DBCC CHECKDB and there's no error messages neither alloc or consistency.
I ran dbcc checktable ('part') with DATA_PURITY and still no errors, but i still have the inconsistency error message whenever i access this particular table.
Any ideas?
-Ricardo Lozano
I am wondering how some of you update your database once it is already been in use. So take for example you have a few tables and users can enter data into the site. Now suppose you either add tables to the db or you add fields to an existing table. I am using sql express 2005 and just want to copy the db over with the copy website but it would overwrite any data users entered.Is there any easy solutions or suggestions for this.Thanks
View 1 Replies View RelatedI am new to the internet field. Can anybody help me in administering the SQL database on the site. Are there any tools so that I can administer the database on the site straight from my PC??? If there, please tell the URLs so that I can refer them. And please tell me other issues which are involved in administering the database on site.
How can I maintain a parellel SQL server database on my PC?? How can I take backup from my site to the SQL database which is placed in my PC?? I want to keep backup of my database in my PC.
Please help me in these issues.
Venkat Reddy
gv.reddy@usa.net
Hi All,Just wondered if i could ask you for some advice and help.I'm looking to write a site, and one of the functions of the site is to remind the user of a certain event at a certain time. I was wondering how i would do this? or if anyone has a working example i could use?Also I dont quite know what database to use...... would MySQL do the function i am after???? If so then no more problem lol If not what database would you recommend i use?ThanksDanny
View 4 Replies View RelatedHi.Does anyone know any web site with common database models presented andexplained.Database models like calendar, adressbook, storehouse...Thnx in advance
View 1 Replies View RelatedI have contracted a webproject to be done. My client allready has a website. I need to create another website that replace the existing one with the new look.
This is the problem. The old website has a Database that is associated with user registration & all other data of the company. So, I need to implement the same database to the new website which I am going to develop.
In this case, how can I start? can I add a SQL express databse to the new project and import the data while the development phase? or should I use a SQL server installed while developing the site?
Please give me an easy to understanable reply that I can deal with the old database?
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:
System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.
Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?
Many thanks to anyone who can help!
Hola!I'm currently building a site that uses an external database to store all the product details, and an internal database that will act as a cache so that we don't have to keep hitting the external database to retrieve the products every time a customer requests a list.What I need to do is retrieve all these products from External and insert them into Internal if they don't exist - if they do already exist then I have to update Internal with new prices, number in stock etc.I was wondering if there was a way to insert / update these products en-mass without looping through and building a new insert / update query for every product - there could be thousands at a time!Does anyone have any ideas or could you point me in the right direction?I'm thinking that because I need to check if the products exist in a different data store than the original source, I don't have a choice but to loop through them all.Cheers,G.
View 2 Replies View RelatedI have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures.
When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message:
Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.Source Error:
Line 143: sqlCommand.Parameters.AddWithValue("@str_ItemName", Trim(DDL_Items.SelectedItem.Text))
Line 144:
Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 146:
Line 147: dl_Description.DataSource = dataReader
Source File: d:hostingcurraheepxdefault.aspx Line: 145
Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server.
This is the Stored Procedure:
CREATE PROCEDURE [dbo].[sp_GetItemInfo]
@str_ItemName VarChar(50)
AS
SELECT TOP 100 PERCENTtbl_pxProducts.int_ItemID,tbl_pxProducts.str_ItemName,tbl_pxProducts.int_RetailPrice,tbl_pxImages.str_SmallImageURL,tbl_pxImages.str_MediumImageURL,tbl_pxImages.str_MediumImageBackURL,tbl_pxImages.str_LargeImageBackURL,tbl_pxImages.str_LargeImageUrl,tbl_pxImages.str_SmallImageBackURL,tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,tbl_LookupCategory.str_Category,tbl_pxProducts.Int_SizeID,tbl_LookupSizes.str_Size,tbl_pxProducts.Int_ColorID,tbl_LookupColor.str_Color
FROMtbl_LookupCategoryINNER JOINtbl_pxProductsONtbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryIDINNER JOINtbl_LookupColorONtbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorIDINNER JOINtbl_LookupSizesONtbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeIDLEFT OUTER JOINtbl_pxQtySoldONtbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemIDLEFT OUTER JOINtbl_pxImagesONtbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID
WHERE(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)AND(tbl_pxProducts.str_ItemName = @str_ItemName)
ORDER BYtbl_LookupSizes.str_Size
Does anybody have any suggestions as to why this stored procedure is failing?
I have build a ASP.NET website with a login form. I can create an account but I am not able to login into the site. I have checked the connection string. I have changed the database folder and moved files around to get the database runing from a different folder but it still wont work.
Thanks
Tim
I've downloaded a copy of Microsoft SQL Server Management Studio Express from MS. Can this product be used to query an SQL database at a web site.
Conversely, is there a command line utility for running SELECT statement queries on my remote web site database?
Greetings,I am in the process of installing a SQL database at a customerlocation. I have determined that there are 3 ways to do this, and Iwanted to know which is the best of the 3.1 Install From Script.In this method I create the database and its objects in scripts thatare run via osql utility on the SQL server machine. For loading anyinitial data that I need in the database I also run bcp commands.2 Install from a backupIn this method I created an empty database on the SQL server, and thenrestore over it the database from a backup of the database that I needto deploy. Then I add or re-attach the users for the database. Iperform all of these operations using osql as well.3 Install by attaching the data files.In this method I created an empty database on the SQL server, and thenI attach the data files to the database using the sp_attach procedure.Then I add or re-attach the users for the database. I perform all ofthese operations using osql as well.Although it is no problem for me to use any of these methods, I wantedto know from you veterans out there what the best practices are. Andalso if there are any unseen hazards for each method above. Or if Iam totally off-the-target, and there is another method that is thepreferred way.Thanks in Advance,roger
View 5 Replies View Related
Hi,
I wanna attach to the database from our domain(ftp site) . it is not in the our network..
thanks,
J
I have been working with Visual Studio 2005 and the Personal Web Site Starter Kit. All is well and working. My problem is that after the database is updated (as in uploading photos and album creation) and the original web site is edited and republished, the web site database is overwritten and all the work is lost. What is the proceedure to either copy the web database to the development site on my computer so updates will not be lost, or a method of publishing that will not loose the up to date content on the web server? I would much prefer to be able to copy the database to my development computer as adding tables to the database is something that needs to be done. Any help on this would be appreciated.
Thanks