How To Start The Commerce Server 2007?

Apr 10, 2007

Hi,



I would like to Learn Commerce Server 2007. I have Virtual PC with Commerce server 2007 install.



I don't know how to start and where to start.



Can any one suggest me for learning commerce server 2007?



Thank you.

View 4 Replies


ADVERTISEMENT

Reg:CSDW_sql, Csdw_olap Datasources In Commerce Server 2007 Dataware House Reports

Mar 25, 2008



hi all,

i unpacked starter site and dw.pup file and i got 34 reports provided by commerce server 2007. i want to edit these reports.
i followed these steps
1)created a "Report server project" in Visual studio 2005
2)In that project in "Shared data sources" folders i added "Startersite_Datawarehouse" of type "Microsoft SQL Server"
3)i added another shared data source name "Startersite_Datawarehouse" of the type "Microsoft SQL services analysis services"
4)later i added one of the reports to "Reports" folder by selecting "Add existing item".
But in design mode of that report when i clicked "Preview" tab i am getting the error
"an error occured during the local report processing. The item /CSDW_olap cant be found"

when i clicked "data" tab i am getting this below error
"Connection cant be made to database"


please help me in resolving this urgent issue....


Thanks in advance,
Archana Devi Papineni

View 1 Replies View Related

Excel 2007 Documents Not Displayed In Windows XP Professional Sp2 Start Menu Recent Documents List

Jan 26, 2007

Excel 2007 Documents Not Displayed in Windows XP Professional sp2
Start Menu's Recent Documents List:



Dear Microsoft Support:
I can't figure out how to get recently used Excel 2007 (new file formats) documents to show up in the Windows XP Professional (sp2) Start Menu's Recent Documents List. I checked the Internet, the knowledgebase, many parts of the MS web site, etc. for an answer but can't find one.
Are Excel 2007 documents supposed to show up in the XP Start Menu's Recent Document List? Is this a bug or do I have to do some sort of configuration to make it do so? If it's a bug, when will a fix be available?

Are these new Excel 2007 files filtered out like EXE files are which will not appear in the Recent Document List?

The Excel 2007 file types are listed in the Registry.

This question is also posted on Experts-Exchange...No solutions yet.

Thanks.


Jim.

View 1 Replies View Related

One-way Hash + E-commerce Passwords

May 8, 2008

Hiya,

I am wondering, in theory, how I would use a typical one-way hash function to protect customer password on my website server (which is a small e-commerce server)?

TRhanks MSDN, as always!

View 3 Replies View Related

How To Get Receipients Email Address In Access 2007 Table From Outlook 2007 Using VBA?

Mar 3, 2008

Hi
everybody.
I am new to VBA,.,, I Have created a folder under inbox in Outlook 2007 which stored the receipients information
like name, E-mail, which is not present in the address book of outlook.
I have imported this folder in access 2007. My problem is ... it does not display the email address.
Rest of the informations is displayed... Is there any way i could do this.??
is there any way i could get the email addresses to appear(import/get) in to the access table???
Is there any module i mite have to create??

Plz help...
thanks a million

View 1 Replies View Related

Server SQL-Server 2005 Crash While Indexing By The Server SharePoint 2007

Feb 7, 2008

Hello,


I have an intranet environment consists of two servers:

- An application server windows 2003 server with 64-bit server Sharepoint 2007 SP1 (Standard version for search)
- A database server windows 2003 server with 64-bit SQL Server 2005 SP2 64-bit (Standard - 9.0.3054)


It happens regularly that the database server crash (frozen black screen) while the application server indexes (crawl) the content of the intranet site based on sharepoint. There is no alert / error in the observer of events, nor in the sql logs.


The crash is uncertain: dice once all goes well, soon after that crash. When i set the parameter search service (service management research), I can define a regulatory impact of the robot to change the number of documents at the same time : "Request 2 documents at the same time, the crash is more rare, "ask 64 documents at a time, the crash is more common.


My Intranet under sharepoint is composed of a collection site with a dozen sub-sites. There are 3 large library of PDF document. All done in the 4 go in terms of volume.


My problem for about 3-4 months. (Maybe more. Before, indexing was not yet in place).

Someone could help me? Thank you

View 2 Replies View Related

Access07 To SQL Server 2007 Through The...

Dec 2, 2007

hi everybody
I've been working in the database field for 9 months
I started from very simple tables, to some sql stuff
And then I started studying SQL Server 2005 extensively until I took MCTS SQL Server 2005
During that time, I was building a database for a new company from scratch, and while I build it for them I keep on reading books and learning, and using this knowledge to upgrade the database
Recently, I could successfully migrate the back-end to SQL Server 2005, and after days of struggling I could connect the front end to it via ODBC in a LAN
My next step is connecting the database through the internet, so I just changed the server name in the DSN file to the address of the server, and opened the ports, but it didn't work....
Can you tell me what's the problem?
Is there a book that can help me do this thing?
I can buy any book and I have the will to learn, provided that I'll apply for MCITP Database Developer next months

Thank you..

View 20 Replies View Related

SCE 2007 And Server 2000

Mar 24, 2008

I have installed System Center Essentials on our network. Everything seems to be working but we are now getting Perflib errors (event id 1008) on our windows 2000 servers. This error indicates there is a problem with our ASP.net v2.xx.xx.xx. We have been unable to resolve this and are looking for more things to try.



View 5 Replies View Related

Excel 2007 DataMining Add-in Database On SQL Server 2005 Destroyed By Using SQL Server Managment Studio?

Apr 26, 2007

Hello,



i have made some Data Mining Model Examples in Excel 2007 (not temporarily!). They where there after leaving an re-opening Excel. I have used them several times. Then I want to look, if I can see them also via SQL Server Managment Studio in the Analysis Services. There where nothing in the DMAddInDB in Analysis Services.

And after this, in Excel my DataMining Models have disappeared and all Models i have made since this disappeared also.



Perhaps I have destroyed the database. But will this happen every time? Can I share Data Mining Models I have made with Excel with Projects in SQL Server Analysis Services?



Thanks

Berenice

View 5 Replies View Related

MS Access 2007 && SQL Server 2005

Apr 16, 2007

Hi,



I have a problem with connecting to our SQL Server 2005 through Access 2007. I get a msg "ODBC-- failed. [Microsoft][ODBC SQL Server Driver][SQL Server] SELECT permission denied on object 'clients', database 'Contacts', schema 'dbo' (#229)" We have moved some of our tables from Access over to SQL Server 2005. I recently got Access 2007 and I'm the only one at the office that has this problem (everyone else uses Access 2003 or older). I can link tables to SQL Server but I can't open them and I can't open Forms or Reports that has those tables as data source. I can open other objects in Access that are not linked to SQL Server.



Does anyone know why this is?



Thanks Charlotte

View 3 Replies View Related

Microsoft Project Server 2007

Sep 10, 2007

Is it possible to run Microsoft project server 2007 on LAN without using Active Directory
Is it possible to keep Active Directory on a separate machine and install project server 2007 on a different machine.

View 1 Replies View Related

Project Server 2007 Analysis Services

Feb 9, 2007

Hmm.. where to start? Well, I have installed proj serv 2007 and have it up and running fine. I was recently asked to get the data analysis portion of the proj server working. After much digging for some guides, I found a few helpful and got sql analysis server installed with everything else it need to operate. (as far as I know). One of the guides that I have encountered and using asks me to use sql studio management to access the analysis server. Problem is, I dont have the option to choose a server type. (Its greyed out) Which only has the option for "Database Engine". Furthermore, I cannont complete the steps required without this option. Could someone please, please, point me in the right direction and possibly tell me what Ive done wrong. Project server 2007 documentation is horrible. Just to be able to use the server has been a process.

View 1 Replies View Related

MS Accounting Exp 2007 Coexisting With SQL Server 2005

Jan 23, 2007

I recently installed MS Accounting Express 2007 which also installed an instance of SQL Server 2005 but without the standard interface. But I want to install SQL Server Express 2005 as well. Can the two coexist? Is there a way to have both applications running on the same machine? I am asking before trying the standard SQL Express install. Thanks, Jim.



View 1 Replies View Related

SQL Server 2005 Books Online (May 2007)

Nov 6, 2007

I downloaded and tried to install the file "SqlServer2K5_BOL_May2007.msi" and got a message:
"This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package."
Please advise.

View 3 Replies View Related

Access 2007 + SQL Server 2005 + Vista X64

Sep 5, 2007

Hello,

I am looking for a solution to the problem named Table was skipped, or export failed. Here's the story:

I have a desktop with Vista Ultimate x64 and Office 2007. I want to export a database from Access MDB (about 2Gb, 110 tables) to SQL Server Express Express (Advanced). The simple solution > upsize wizard.

- create new database
- server name, used trusted connection, some database name
- I select all tables
- I unselect table's attributes
- create new Access server/client application
and every time I have Table was skipped, or export failed. The same thing happens when I create new MDB with one table (some random values)!

The strange thing that on laptop with XP + SQL Sever 2005 Express (Simple) and Access XP upsizing the same database works fine!'

one other issues of a rookie:
I wanted to access a database (randomly created) on Vista with the Access on my laptop. Both PCs are in the same network I can ping both, but when I try to connect to IP_desktopSQLEXPRESS Access posts connection error. Why?

P.S.
When installing SQL Server on Vista I have only a problem with IIS and ASP.NET, but it shouldn't be a problem.

View 1 Replies View Related

MS Access 2007 Db Upsizing T0 SQL Server Express 2008

Apr 24, 2008

Hi Folks,
I have an access 2007 data base for document control and it saves the received documents in a table in a attachment field type, I tried to upsize it to SQL Server 2005 but after upsizing realized that this field type is not supported by 2005 so I downloaded the SQL Express 2008 and installed it as it has this enhancement but Access 2007 doesn’t recognize the server for upsizing.
I appreciate you help
Thanks :beer:

View 13 Replies View Related

SQL 2005 X64 Linked Server To Excel 2003/2007

Aug 27, 2007

Is there a way to create a SQL 2005 x64 Linked server to an Excel (or Access) 2003/2007 file? In SQL 2005 32bit this was possible. Does anyone know of a solution or a work around?

View 3 Replies View Related

Importing Excel 2007 And/ Or DBF Files Into SQl Server 2005

May 12, 2007

Greetings,

I'm having a tough time importing some of my legacy database into sql.
I have a number of dbase (IV) files I need to get into SQL. I have tried building a SSIS package with either an foxpro oledb connection or a jet 4.0 one, none of them work bec. of inconsistencies in the data format in my tables (e.g. date fields, etc).

I have tried to save the .dbfs as excel 2007 files, taking advantage of the larger space that comes with '07. Problem is you can't use the import/export wizard with 2007 for some reason and I haven't been able to create a package with the access 12 oledb as I have read.

I have to get some crucial data out of that old system and into the new one and I can't seem to be able to import them properly.

Any hints on what I should do ? (maybe I'm doing something awfully wrong)

Thank you for taking the time to answer my question,
Val

View 12 Replies View Related

Export To EXcel 2007 Using SQL Server 2005 Express

Dec 8, 2007

Hi all,









Posted - 12/05/2007 : 01:54:18





How to export data from SQL Serevr 2005 Express to Excel 2007 using OPENROWSET command.

I have tried the following code But getting error
sSQL.Format("insert into OPENROWSET('Microsoft.JET.OLEDB.4.0','Excel 8.0;Database=%s;','Select * from [%s$]') select * from [%s]", sExcelPath, sSheetName, sTable);

But getting the following error

The OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)" reported an error

I am using automation object for creating EXcel .I have added the header also.

Any help is appreciated

Thanks

View 5 Replies View Related

Problem Using DPM 2007 To Protect SQL 2005 On Server 2008

May 18, 2008

I have a problem protecting a SQL 2005 SP2 server on Windows Server 2008 (64bit), running DPM 2007 on Windows Server 2003 (32 bit).

The following SQLVDI event ID 1 is logged in the event viewer:

SQLVDI: Loc=SVDS:pen. Desc=BADMEM. ErrorCode=(-1). Process=2972. Thread=6504. Server. Instance=MSSQLSERVER. VD=Global{CC60D260-C5DD-406A-9E63-64A9503A9763}1_SQLVDIMemoryName_0.


The UUID changes each time the event is logged, but the first event is followed by:

SQLVDI: Loc=SVDS::Cleanup. Desc=Close(channel). ErrorCode=(6)The handle is invalid.

. Process=2972. Thread=6504. Server. Instance=MSSQLSERVER. VD=Global{CC60D260-C5DD-406A-9E63-64A9503A9763}1_SQLVDIMemoryName_0.

Then this is repeated twice:

SQLVDI: Loc=SVDS::Cleanup. Desc=Close(channel). ErrorCode=(6)The handle is invalid.

. Process=2972. Thread=6504. Server. Instance=MSSQLSERVER. VD=.


Event ID 3201 is then logged by MSSQLSERVER:

Cannot open backup device '{CC60D260-C5DD-406A-9E63-64A9503A9763}1'. Operating system error 0x80770006(error not found).


This is followed by Event ID 3041:

BACKUP failed to complete the command BACKUP DATABASE CommunityServer. Check the backup application log for detailed messages.


It looks to me like the virtual device creation fails in the first step, the next three event messages are the cleanup of the failed virtual device, and the final two messages are the failed SQL backup as the expected device doesn't exist.

My question is why? The message seems to indicate bad memory, but I'm sure the physical memory is good - The 16GB in this server has been tested extensively, and I have no other issues. Perhaps its some sort of memory allocation error?

I'm going to apply cumulative update 7 to this SQL server to see if it makes a change. What's the latestest version of sqlvdi.dll available?


TIA,
Karl.

View 1 Replies View Related

Business Contact Manager 2007 && SQL Server 2005

Jan 28, 2008

I'm looking for a little help on a strange problem, used Business Contact Manager 2007 Database Tool to create a shared database in SQL Server 2005 on a server on the LAN, placed the database in the default instance of MSSQLSERVER then used the database tools to restore a 2003 BCM database to the newly created database in SQL. Everything worked as it should and I verified the database existed and was populated with data and all the permissions were set correctly to access the database. Then I loaded 2007 Business Contact Manager on a workstation on the LAN and attempted to use the wizard to connect to the remote database. I keep receiving errors that the database cannot be found. I have used the SQLCMD (Sqlcmd €“S €śtcp:erverNameinstanceName,portNumber€?) to verify access to the server and named instance and can connect with no problem, so it appears that would eliminate any firewall (which I turned off) problem or permission problem on the SQL Server. This is a connection between a Vista computer and a Server 2003 domain controller. DNS appears to work without a problem as a ping from the Vista machine by server name yields the correct IP. I have several databases running on the sequel server and have no problem accessing them. Any help would be greatly appreciated.

View 3 Replies View Related

Sharepoint Server 2007 And SQL Server 2005

Dec 6, 2007

Hi all!
I'm VERY new to MOSS2007 and I have couple of questions about it and SQL Server 2005. The basic idea is to receive data from MOSS2007 into SQL Server 2005 in my own database and make some reports from there.

Which are the best practices to receive data from MOSS2007 into SQL Server 2005? Do I have to write some dlls for example with VB.NET (and use Sharepoint API calls) and use those dlls in stored procedures in SQL Server 2005? Or can I just use normal T-SQL (I believe that data in MOSS2007 is saved in lists and lists are saved in DB)?

Waiting for your replies. The more detail your answer is the more grateful I am!

Thanks!

Best Regards,
Harry F.

View 1 Replies View Related

Sharepoint Server 2007 And SQL Server 2005

Dec 6, 2007

Hi all (and sorry for crossposting)!
I'm VERY new to MOSS2007 and I have couple of questions about it and SQL Server 2005. The basic idea is to receive data from MOSS2007 into SQL Server 2005 in my own database and make some reports from there.

Which are the best practices to receive data from MOSS2007 into SQL Server 2005? Do I have to write some dlls for example with VB.NET (and use Sharepoint API calls) and use those dlls in stored procedures in SQL Server 2005? Or can I just use normal T-SQL (I believe that data in MOSS2007 is saved in lists and lists are saved in DB)?

Waiting for your replies. The more detail your answer is the more grateful I am!

Thanks!

Best Regards,
Harry F.

View 1 Replies View Related

Configuring Sql Server 2005 For Office 2007 Data Mining Add-ins

Mar 3, 2008

after i installed sql server 2005 DM add-ins, i tried using it with office 2007 so i choose (start---->all programs----->microsoft sql 2005 dm add-ins---->getting started) so the getting started wizzard was opened, i selected from it (use an existing instance of microsoft sql server 2005 analysis services that i adminster) because i already had a version of it installed on my computer. then i tried to connect to analysis services by selecting 'server name'=local host, an error appeared which is "unable to discover meta data on the server 'local host' . user noha needs to be adminstrator of the server to run the configuration tool". how can i be the adminstrator of the server?????????.........plz reply me soon,thanks in advance

View 6 Replies View Related

SharePoint Server 2007 Integration With Reporting Service 2005

Jan 18, 2007

Hi,

I am working on sharepoint 2007 integration with reporting service 2005. There are few facts which i am trying to understand and need some clarifications. Please provide your comments

1) While configuring "Database setup" in Repoting Service Configuring Manager" i found two modes 1) Native and 2) SharePoint Integration. When creating a report server database if we check "Create the report server database in Sharepoint Integration Mode" then it set the mode to "SharePoint Integration Mode". There is no option of switching the same database to native mode. So i have to create another database in "Native Mode". (IS THIS CORRECT. DO WE NEED TO CREATE TWO REPORT SERVER DATABASE SEPERATE FOR SHAREPOINT INTEGRATION AND NATIVE)

2) I am using the new report viewer web part in sharepoint 2007. When i am in sharepoint integration mode i can create datasource, report model and with report builder i can create rdl file. On selecing any RDL file in doument library and it gets displayed in Report Viewer Web Part. When i switch to Native mode i want to configure the web part to use the report created with SQL Server Bussiness Intelligence Dev Studio and deployed on http://localhost:808/ReportServer. (IS THERE ANY WAY SO THAT I CAN EXPORT AND IMPORT ALL .RDL FILE FROM http://localhost:808/ReportServer to http://localhost/ReportServer)

I AM NOT ABLE TO CONFIGURE WEB PART WHEN I AM IN NATIVE MODE i.e giving path of .RDL in report textbox throw a error saying "Item not found" i tried all combination. THIS can be related to datasource not reading in .RDL file in native mode while confuring report viewer web part.

http://localhost:808/ReportServer (Report Server)

http://localhost/ReportServer (SharePoint Mode) (Default Top Level Site)

3) LAST : I want to create a .RDL file report from the data in sharepoint, say lists or news etc. So when creating a RDL file how can i connect to sharepoint database. I read some where that in previous release they used to DATA EXTENSIONS and get the data from list in sharepoint with something like http://<servername>/<sitename>/List=Announcement when creating RDL file. Is the alternative in new release to create the report based on sharpoint list data.

Thanks and i would really appreciate your help

View 3 Replies View Related

How To Create Linked Server To Access 2007 Accdb File?

Feb 20, 2008

How does one create a linked server to an Access 2007 (accdb) file? I am aware that to create one to a mdb file, the code would be -EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:MSOfficeAccessSamplesNorthwind.mdb'
GO
What is the corresponding code for Access 2007 accdb files?

View 18 Replies View Related

SQL 2007 Query Designer Using 4 Part Naming Linked Server - Bug ????

Jul 6, 2007

I have a linked server in SQL 2007 form SQL to DB2.(IBM)

If I write a distributed query from SQL to DB2 I get mt data returned.
ie:
select *
from openquery(Movex_Extranet,'Select * From mvxadta.ooline')

If I write a Query from SQL to DB2 using the 4-part naming convention linkserver.catalog.schema.object
then I also get my data returned.


ie:
select *
from MOVEX_EXTRANET.RCHASE5C.MVXADTA.OOLINE

My problem is with the Query Designer in SQL2007.

When I right click the first lot of code and select "Design query in editor"
The Designer GUI opens up and displays my table in graphical form with all columns selected - Great.



But When I repeat this for the code that uses the 4 part naming
The Designer opens up and displays the table but with no columns viewable or available for me to select ??

Anyone know what might be causing this to happen.
Is it a bug in SQL 2007 ??

I have tried linking the server using 2 types of providers ( One from Microsoft & one from IBM) but each time I still cannot see or choose columns in the designer using the 4part naming convention.


The 2 providers I tried where.
Microsoft OLE DB for ODBC Drivers.
IBM DB2 UDB for Iseries IBMDA400 OLE DB Provider



Any help greatly appretiated as I would really love to use the designer using 4part naming convention.

Apparently if you read this the it should work ?
http://msdn2.microsoft.com/en-us/library/aa225987(SQL.80).aspx#dvmscworkingwithtablesfromdifferentdatasources


Ray

View 1 Replies View Related

SQL Server Instances For Business Contact Manager 2007 Database?

Feb 26, 2008



Hi, i have created a database in business contact manager which is currently been used by five toher employees. I was trying to move that database to my server. Well I found this tool online called "Business contact manager 2007 database tool". I am trying to run it on the server but it is giving me a following error:

"Cannot retrive the list of SQL Server instances. Please make sure that SQL Server 2005 or SQL 2005 Express is installed and that the service is running."

I have SQL 2005 installed on my computer and I dont have any idea how to resolve this issue. It would be great if someone could help me.

View 1 Replies View Related

SSRS And Office Sharepoint Server 2007 Configuration Problem

Sep 27, 2007

Hi!

I'm configuring now Reporting Services on SQL Server 2005 in Office Sharepoint Server 2007 integration mode. In the beginning of the process, I had already installed SQL Server 2005 with RS and Office SPS 2007. I used following guides to make further steps:
How to Configure Reporting Services to Use a Non-Default Web Site (Reporting Services Configuration)

How to Configure Service Accounts (Reporting Services Configuration)

How to Configure SharePoint Integration on a Standalone Server
How to Configure the Report Server Integration Feature in SharePoint Central Administration

Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services

So I installed RS add-in for SPS, made RS configuration and almost all SPS configuration. I stopped with error

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. " in "Set server defaults" command.

My servers configuration is following:
1. Both RS and SPS are running on the same server.
2. I cannot change port of default web site, so I made different web site "Reporting services" under same web server with port 8086 (http://mtx-sps2007:8086/reportserver)

3. RS Windows service runs under domain system account that is a member of local Administrators group (account name sql2k5sps7)
4. RS Web service runs under NT AuthorityNetworkService account
5. Database connection configured using mentioned above account sql2k5sps7

6. Report Server Web Service URL in SPS is set to http://mtx-sps2007:8086/reportserver
7. Authentication Mode in SPS is set to "Trusted account"
8. My account, under which I make a connections through terminal services to SPS and RS servers and through http to reportingservices page is a member of local administrators group of both my PC and server.
9. I'm not familiar with SPS (honestly speaking, with RS too, but at least I learning this quickly, but SPS is out of my responsibilities scope)
10. ReportServer runs under separated app pool that runs under NT AuthorityNetworkService account


And now I'm fighting with this error on "Set server defaults" command. It's interesting that from my PC there is no credentials prompt when entering SPS administrations page and error is following:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode
But from terminal client, connected to SPS and RS server, there is a credentials prompt (I enter my credentials) and error is as mentioned abowe:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found.
Also, the same error I got when I tried to add a report to report viewer web part on SPS test page.

Can anyone help me with this? I would be greately appreciated to any help on resolving this issue.

View 4 Replies View Related

SQL Server 2005 Reporting Services Integration With SharePoint 2007

Jun 30, 2007

Hello Everyone,



I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services. I have been following these 2 websites down to the letter in trying to configure everything:





1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx <---Microsoft's Steps


2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx <---SharePoint Blog Group





Basically my setup is as follows:



Server 1 = SharePoint 2007

Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services

Server 3 = Database



Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.



This is where the headache begins....the SharePoint install is successful on Server2 and the services are started as evident through the Central Administration page. The next task is to install SQL Server 2005 Reporting Services and then the SQL Server 2005 SP2 patch.



After installing SQL Server and the SP2 patch, you go into the SQL Reporting Services Configuration Manager and setup the Report Server, Database, and SharePoint integration. I configure everything to run under the "DefaultAppPool" under IIS, and I get green accepted checkboxes on everything.



Finally, the last step is to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on Server1. This add-in actually allows the connection between SharePoint on Server1 to the Reporting Services on Server2. The install is successful and the extra options for reporting pop up under Central Administration page. When configuring the final connection under the Central Admin I referred to the following Microsoft Page:



http://msdn2.microsoft.com/en-us/library/bb326213.aspx



For the "manage integration settings", I set the report server to Server2 and use Windows Authentication. Then for the "grant database access" I use Server2 and login with my credentials...



PROBLEM: Then for the final step of setting the server defaults, I click on the link and get the following error:



"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. "



I have googled and tried installing/uninstalling several times, but it seems that I keep getting hung up here. When trying to access reports on the ReportServer, the same error message comes up.



If anyone is familiar with integration between SharePoint and SQL Reporting Services, and may have any ideas/comments/advice, I would greatly appreciate it. Thanks in advance! =)



--A4orce84

View 4 Replies View Related

Sharepoint Server 2007 Products And Technologies Configuration Wizard

Nov 22, 2007



Hi,
I tried to install sharepoint server 2007 as a standalone in my computer. When i run the sharepoint products and technologies configuration wizard, i get the following error,

Failed to create sample data.

An exception of type System.Data.Sqlclient.SqlException was thrown. Additional Exception information:
Cannot open database "SharedServices2_DB_28aa01d8************************" requested by the login. The login failed.
Login failed for user "domainAdministrator"

Please advice me to solve this issue.

Thanks,
Magesh S

View 18 Replies View Related

Migrating Reporting Services 2005 With Integrated Sharepoint 2007 To Another Server

Sep 27, 2007

hello good afternoon, I am having this issue, I need to move reporting services from one server to another, but I need that credentials, roles and reports stay the same. But as the reporting services is integrated with sharepoint, dont know if I can move both at the same or it has to be done one at a time. this is just data migration, but still I will like to Know how it can be done having the same structure with the roles and credentials. or it is prefered to do a ghost?? but the issue will be that we have the reporting services in one place and the data in another... don´t know how this will affect. thanks in advanced for the help.

View 1 Replies View Related

Windows SharePoint 3.0 And Project Server 2007- Error On Rebuild Of Site

Nov 13, 2007

My 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?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved