How To Configure Filegroups On Multiple Machines - SQL 2005

May 15, 2008



Hi folks,

I am exploring various solutions to setting up a scalable database configuration. To do a proof of concept, I need to setup the database in such a way that the data is partitioned on 2 physical machines.

I looked at distributed partitioned views, which allowed me to create a table on databases residing on two different servers, and then I created distributed view (with appropriate range constraints) that supported distributed selects, joins, updates, and inserts. This seemed to be the solution we were looking for.

However, I ran into a major problem because of the fact that distributed partitioned views don't allow a table to maintain an Identity column with an identity seed.

I did more research and found the Partitioned Table concept that was introduced in SQL 2005. This partitioned table allows us to have a single table which is horizontally partitioned across multiple file groups. This table now is just like a regular table in that it supports the identity column and identity seeds and guarantees index integrity. We were successful in implementing the partitioned table on a single machine, with three filegroups.

Now I need to move these file groups to different physical machines. I have found some articles on adding file group on additional hard disks on the same machine - but nothing to setup a database that is comprised of multiple servers that each handle a part of the data partition.

Is it possible to create a database comprise of filegroups residing on different physical machines?

Thanks.

View 12 Replies


ADVERTISEMENT

Do/can Multiple Filegroups Really Make A Difference When Only One Disk Drive Is Involve?

Sep 27, 2007

outside of restore manageability, can multiple filegroups enhance performance when only one disk is attached? I guess I should also ask if it can hurt?

I have two use cases and am a bit unclear after reading lots of material on the subject.

My first use case is an OLTP consisting of a very stable set of "configuration" tables and a volatile transaction intake table with RI on the stable tables. I thought about putting the volatile table in it's own filegroup due to it's behavior but am second guessing myself after seeing that every author on the subject seems to hint that filegroups are only relevant when they map to different disks.

My second use case is an archive (readonly) that I will "range" partition due to volume. My first instinct was to create one filegroup for each partition but again I'm wondering what that will buy me in an environment with only a single disk.

View 3 Replies View Related

Restoring Filegroups In 2005.

May 3, 2007

Howdy all. I want to be able to restore just 1 filegroup from a filegroup backup, without having to restore the log afterwords even if the data has changed post filegroup backup. While this would leave the data inconsistant, it may be desired at times. From BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2f552700-efb3-48f1-b96d-c073049100f0.htm

************************************************** ******
If the files have been modified after the file backup was created, execute the RESTORE LOG statement to apply the transaction log backup, specifying:

The name of the database to which the transaction log will be applied.
The backup device from where the transaction log backup will be restored.
The NORECOVERY clause if you have another transaction log backup to apply after the current one; otherwise, specify the RECOVERY clause.
The transaction log backups, if applied, must cover the time when the files and filegroups were backed up until the end of log (unless ALL database files are restored).
************************************************** ******

But thats just it, I may not want to take this action. Maybe some data got deleted from a set of tables in a filegroup right after I took my last filegroup backup, so I just want to restore that filegroup back to that backup, but leave my other filegroups alone. Restoring the log brings the data back to a consistant state when the log was backed up, which may not be what I want.

Can this be accomplished?

TIA, cfr

View 2 Replies View Related

List Of Sql Server 2005 Machines

Jun 17, 2008

Hi,
How do I get a list of sql server 2005 machines from the network please?
Thanks

View 1 Replies View Related

Change Table Filegroups On 2005

Aug 13, 2007

I have approximately 400 - 600 tables that need to have their filegroups changed on a new SQL 2005 installation. In 2000, I could go the table properties in Enterprise Manager and change the filegroup, but on 2005 Management Studio, I can view (but not change) the table properties.

I realize that I can create the table on the other filegroup using a new name, move my constraints and indexes to this new table, copy the data over, drop the original table, then rename the new table to the name my application is expecting. But that could take me weeks (especially with such a time-consuming process)! I don't mind the process being so slow, but I do mind it being labor intensive.

Does anyone have an idea how I can automate this process (or at least make it as easy as it was with Enterprise Manager?)


Paul Teal

View 3 Replies View Related

Database Access By Machines Running SQL Servers 2005 32-bit And 64-bit

Oct 11, 2006

Hello

We have 1 machine running SQL Server 2005 x64 (64 bit). The other machine is backing this SQL Server up. It is a 32-bit machine, so it requires (?) a 32-bit version of SQL Server 2005.

Would this back-up machine work correctly on a database previously managed by a 64-bit machine and vice versa.

Thank you!

View 3 Replies View Related

Multiple Parameters - How To Configure The Logic?

Apr 15, 2008



Hi,

Im trying to set up a report in visual studio 2005 which uses multiple parameters (6) on which the user can filter to get the information they want.

here is what i want to happen - I've tried to explain as best i can but i dont think i've done a very good job...please ask questions if things need clarifying:

the 6 parameters are - userid, printers, default printer, area, applications, supervisor.

these need to be able to be filtered on any/all/combination of those parameters. parameters are set up and data is accessible, however when i run the report and try and filter on these it only works if all parameters are set to "All" (this is made available through a UNION select statement), or if i individually select a value for each category. if i choose a combination of say userid =myname, printers = myprinter, default=all, area=all etc it will match if ANY of the criteria is matched (including the ALL criteria, therefore it will always display all the values). i need to it work so if i pick the userid and the printer it will only match records containing BOTH the values i select, not either, or if i choose just the area, it will only return those records that contain that department.


Below is the WHERE statement i am currently entering in


WHERE (AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (((AllUserData.nvarchar3 LIKE @Area) OR (@Area = 'All')) OR ((AllUserData.nvarchar4 LIKE @Default) OR (@Default = 'All')) OR ((AllUserData.ntext1 LIKE '%' + @Printer + '%') OR (@Printer = 'All')) OR ((AllUserData.ntext2 LIKE '%' + @Application + '%') OR (@Application = 'All')) OR ((@Application = 'All') AND (@Printer = 'All') AND (@Default = 'All') AND (@Area = 'All')))

and here is what Visual Studio automatically translates that into as soon as i execute the script:


WHERE (AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (AllUserData.nvarchar3 LIKE @Area) OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (@Area = 'All') OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (AllUserData.nvarchar4 LIKE @Default) OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (@Default = 'All') OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (AllUserData.ntext1 LIKE '%' + @Printer + '%') OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (@Printer = 'All') OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (AllUserData.ntext2 LIKE '%' + @Application + '%') OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (@Application = 'All') OR
(AllUserData.tp_ListId = '36948548-bfa8-4b25-aff8-b3d1f401dca1') AND (@Area = 'All') AND (@Default = 'All') AND (@Printer = 'All') AND
(@Application = 'All')


Note: AllUserData.tp_ListId references a specific row in the database which must be queried to get the correct information. so it must match on that before anything else.

any help structuring the logic i am using or better understanding the way visual studio/sql handles this kind of thing would be fantastic! thanks!

Shannon

View 2 Replies View Related

Can't Connect From A Vista Client To SQL 2005 Box,other Machines Work Fine

Oct 27, 2006

Hey. I've a windows vista machine which can't connect to SQL 2005 box. Other machines which are lower than vista work fine. Also, vista box can connect to other SQL 2005 instances but can't connect to only one instance. But, I can connect to the instance fine from my XP box. Also, it's not a permissions issue. This user is an SA and can connect form some other machine. SQL 2005 box is at 2047 version right now. And, the user is able to connect to some other boxes which are also at 2047. Please help. Thank you

View 1 Replies View Related

How Do I Connect Client Machines To SQL Server 2005 Installed On A Windows 2003 Server

Apr 11, 2008

I am new to SQL server 2005


Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.

I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):

These are two things that I need to facilitate:

1) They want to be able to write queries using Query Designer and run from their PCs.

2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.

3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.

Any suggestions are appreciated, especially with item number 1.

View 9 Replies View Related

SQL Server 2005 Stored Procedures Running On Server 2003 Machines

Jan 20, 2006

Stupid question but please be gentle and answer anyway please....

Background: We have SQL Server 2003 (32bit) running on our servers. Our .Net applications (from old release of VS) are still running on them and using the old databases. From what I understand there is no immediate plans to upgrade the servers. However the developers were just given this new upgrade (2005) SQL Server and VS (and fixing depreciated code etc in the .net apps).

Question: Can the applications and new stored procedures written via the 2005 environment be deployed successfully on the 2003 Servers? Same goes with Reporting Services?

View 1 Replies View Related

How To Configure SQL Server 2005

Dec 17, 2007

Hi All,
I am new to SQL server 2005. I have installed SQL server 2005 which came along with the visual studio 2005 package. Now i could see the visual studio 2005 in the installed programs list.
I really dont know how to configure the the installed SQL server. how to create tables and veiw. frankly speaking i could not see where is the head and tail.

To be straight forward, i havent used any database to a great extent. earlier during the starting of my career, i developed a small application using VC++, which used to interact with the DB server on a very minor scale; whenever i wanted to create a table for used to do it with sql client which was also installed in my machine.

currently i am againg devoloping a small apliccation using VC++, this time for devlopment and testing purposes, I have SQL server 2005 installed in the same machine which i am using for development.
Now as i said eralier i am not even aware how to configure, how to start creating table...... :-(

all i have done is i have installed SQL server 2005 and all i could see is SQL Server 2005 listed in the installed programs list :-(
some one please help me.... :-(

I couldnt even create a DSN

Thanks and Regards
RK

View 1 Replies View Related

How To Configure Sql 2005 To Use Trackit!6.5

Mar 6, 2008



i have trackit!6.5 application which works as follow:
when installing it and if there is no sql server is installed then he install sql desktop and the application works fine
now i want to use sql server 2005 instaed so i keep getting that error
login failed for user trackit65 also i added myself
so any idea ??
which schema or member ship shall i use
also i got error event id 18456 with no ERROR STATE listed with it

View 1 Replies View Related

SQL Server 2005 Setup Of 2 Vista Machines, Can't Get Individual Network Login Accounts To Work On Each Others SQL Server

Apr 16, 2008


Hello all,

I have 2 networked PC's both running vista ultimate

1st is Laptop and is running its own SQL Server at laptoplaptopSQL
2nd is Desktop and is running its own SQL Server at desktopdesktopSQL

Now both machines have seperate windows login accounts.

When I go SQL Server management studio I go to browse and each machine can see the other machines SQL Server, but when I go to login I get SQL Login falied for users" The user is not associaed with a trusted SQL server connection".

So I then go to logins new login and try to add my other pc's user account.
The problem I see is that when I go to search and then location it only shows its own PC's location and not the location of my other networked pc? So if I am on Desktop and in my theory want to add laptopuser to the desktop SQL Server logins I get:

"create failed for login laptopuser

An exception occurred while executing Transact SQL statement laptopuser is not a valid windows NT name. give the complete name


Not sure on where to go from here.

Any help would be great

View 10 Replies View Related

How To Configure SQL Server 2005 Standard..

Jan 3, 2007

Login failed for user ''. The user is not associated with a trusted SQL Server Connection.

Ive got this error... I have just installed the SQL Server 2005 Standard Edition. Could anyone encounter and solve this problem.. please til me how to solve this. I google this but couldnt find a reliable solution for this..

Thanx...!

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If

View 10 Replies View Related

How To Configure An Enterprise Deployment Of SQL 2005

Jul 26, 2006

I€™m interested in reading about best practices or
recommended deployments for MS SQL 2005.
Currently our company owns 8 x SQL 2005 Enterprise Processor licenses. We have 4 HP DL380€™s with the following
configurations:



6GB RAM

Mirrored
72GB drives for OS (Windows 2003 Ent R2)

4TB Shared
storage (SAN) (15K Fiber Channel)

Dual 3.6GHz
Processors



We would like to create a highly available data
warehouse. We considered running the
SQL engine on one set of servers (Cluster 1) and running the reporting, analysis,
browser, etc., services on the other set of servers (Cluster 2).



Is this possible with MS SQL 2005?

How do we install and link all the servers together?

Is this a poor design?

With the above hardware and software, what would be the best
deployment for availability, distributed processing, speed, and reliability and scalability?




Thank you.



=G

View 1 Replies View Related

This Is How You Configure A DB2 Linked Server In MS SQL 2005.

Jul 26, 2006


With Linked server you can access DB2 resources as if it is another object in your SQL Server.

You don€™t have to establish links from all nodes to the DB2 Server.

Connection from SQL server 2005 to DB2 Server is sufficient to all SQL server users to access DB2 resources.



1. Install MicroSoft OLE DB provider For DB2 in SQL server 2005.

2. configure as follows:
Start - - -> all programs - - - > MicroSoft OLE DB provider For DB2 - - - > Data Access Tool.
Right click on data sources - - -> New Data Source
In Data Source Wizard - - > Data Source plat form = DB2/MVS or any other appropriate plat form from drop down
Net work type = TCP/IP - - > Next
Address = IP address:xx.xx.xx.xx

Port Number: xxxxxxx - - -> Next
Initial Catelogue = SAMPLE
Package Collection = DB2INST1
Default schema = DB2INST1
Default Qualifier = Leave it blank - - -> NEXT
HOST CCSID = EBCDIC- U.S./Canada[37] or appropriate one
P.C Code Page = ANSI-Latin I[1252] or appropriate one
Process Binary as character = check the box - - -> NEXT
Interactive sign on - - - > select it
Provide login name and password.
Check "Allow Password saving" - - - -> NEXT
Check appropriate boxes like read only etc. - - -> NEXT
Click Connect tab - - -> make sure "Success ful" message is appearing
Example: - "Successfully connected to data source 'DB2-server'.
Server class: DB2
Server version: 8021.00.0000"
- - - -> NEXT
Provide a data source name.(Example: DB2-Server)
Check initialization string option - - - > NEXT
Review completed task list on the window and
Select "FINISH" to complete the work.
The data source which you have added just now(DB2-Server) will be appearing on the grid now.
right click on the data source name and make a note of the path where it has formed
right click on the data source name and click "Display connection string"
cut and paste this connection string on the lower window to note pad for future use.

Start MS SQL server Management studio
Add a fresh linked server in 'SQL Server - - > Server Objects - - -> Linked Server" as follows:
Click Mouse right button on linked server and select "New Linked Server"
linked server = Provide a meaning ful, fully identifiable name for Linked server(Example"DB2-Linux")
Provider = MicroSoft OLE DB provider For DB2
Product name = DB2OLEDB
Data source = IP address

Provider string = Paste the connection string pasted to note pad earlier.
Location = Leave it blank
Catalog = SAMPLE
Click on security on the left side pane
Provide an SQL Server login from the drop down
Do not select check impersonate
Provide DB2 username and password and remote user name and password.
Click OK to save.
You will find the name of liked server appearing below the object Linked Server(Example "DB2-LINUX")


Open a new query window and execute an open query
Example:
SELECT * FROM OPENQUERY("DB2-LINUX", 'SELECT * FROM SAMPLE.DB2INST1.EMPLOYEE')


In the Example "DB2-LINUX" is the name of the linked server
"SAMPLE.DB2INST1.EMPLOYEE" is the name of the table. Sample = name of the db
DB2INST1= name of schema to which the table belongs to
Employee = name of the table

Another Example would be
SELECT empno,FIRSTNME FROM OPENQUERY("DB2-LINUX", 'SELECT * FROM SAMPLE.DB2INST1.EMPLOYEE')


View 1 Replies View Related

Could Not Configure Server As A Distributor (SQL 2005)

Jul 21, 2006

Arghh ...

I have searched all the newsgroups and applied or tried all the suggestions, with no success. I have completely uninstalled and reinstalled SQL 2005.

Can someone point me in the right direction? Here is the error I receive when I try to 'Configure Distribution' in the SQL 2005 management studio.

Any/all help is greatly appreciated.

Tery
PS. The destination path mentioned in the error is definitely a correct path.



TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------

SQL Server could not configure 'LAPTOP' as a Distributor.

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '5'.
Invalid destination path C:Program FilesMicrosoft SQL ServerMSSQLData.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15121)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15121&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


View 4 Replies View Related

Help With How To Configure SQL Server 2005 To Allow Remote Connections

Nov 14, 2006

Hi there! I've been trying for several days now to configure SQL Server 2005 to allow remote connections, apparently, with no luck.
I always have this error message: Microsoft SQL Native Client: 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.
I've followed the instructions at this link -> http://support.microsoft.com/?kbid=914277&SD=tech, but I have been having the same problems.
I've already adjusted my firewall settings.
What should I do? 
Please help me...
 

View 2 Replies View Related

Configure SQL Server 2005 To Allow Remote Connections!!

Jan 17, 2007

Hello there,
I just deployed a new ASP.NET 2.0 website on a remote server http://www.alrazem.com/. and when i want to log on, or when any connection to the database happens!! the following error ocurs.

Server Error in '/' Application.


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)
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: 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)Anyways, I searched the new. and i found this link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277... I followed the instructions and changed the Surface Area Configuration for Services and Connections to  Local and remote connections. and Applied both protocols. Then redeployed the application. but the error still ocurs.
I didn't restart my machine after changing the SQL to remote. but i did the website from scratch again. and created a new connectionstring and database!!!
Any help? Thanks!

View 1 Replies View Related

Configure Sql Server 2005 For Remote Hookup?

Nov 15, 2007

Ok. Here is what I need to do: several computers on the intranet need to use a client program to access data from the server (a desktop)

Here is what is going on:

1. I am using Visual Studio 2005 c#.net 2.0
2. Sql Server Express 2005
3. I don't have IIS set up
4. The database is being shared from the c drive on the server (not sophisticated at all, but this is a one man operation!)

Questions:

1. Is IIS an absolute must to make this happen?
2. If not, a user pointed out that I can't use UNF to access the database. How do I set up the connection string to access the db on the server?

This is my basic connection string (local)

connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:MonzaDBMonzaDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;Asynchronous Processing=true"

Thanks for any help on this subject. I know basically nothing about NETWORK programming and database administration!

View 4 Replies View Related

Connecting SQL Server 2005 And Web Server (IIS 6.0) That Are On Two Different Machines

Mar 27, 2008

I am developing a web application. The database required for the application is in SQL Server 2005 installed machine. In another machine where the IIS 6.0 alone is installed, the compiled application is present. How do I connect web server with SQL Server 2005 so as to access data?

View 4 Replies View Related

Cannot Configure SQL Server Express 2005 For Remote Connections

Aug 15, 2006

Hello. I have SQLEXPRESS 2005 installed on my laptop running Windows XP Home Edition with SP2. I have an application that can connect to the local instance with no problem. The other day, I tried to configure SQLEXPRESS 2005 for a remote connection from my desktop. To date, I have been unable to figure out how to do this.

I have followed the instructions posted at various locations on the internet, but to no avail. While I can configure SQLEXPRESS 2005 to allow TCP/IP connections, I have been unable to restart the server.

Here is the pertinent snippet from the error log:

<time> Server A self-generated certificate was successfully loaded for encryption.
<time> Server Error: 26024, Severity: 16, State: 1.
2006-08-14 21:02:27.18 Server Server failed to listen on 'any' <ipv4> 0. Error: 0x277a. To proceed, notify your system administrator.
<time> Server Error: 17182, Severity: 16, State: 1.
<time> Server TDSSNIClient initialization failed with error 0x277a, status code 0xa.
<time> Server Error: 17182, Severity: 16, State: 1.
<time> Server TDSSNIClient initialization failed with error 0x277a, status code 0x1.
<time> Server Error: 17826, Severity: 18, State: 3.
<time> Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
<time> Server Error: 17120, Severity: 16, State: 1.
<time> Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I have a feeling this problem is due to the way my system is configured, not necessarily how my SQLEXPRESS 2005 is configured. My laptop and desktop are connected via a wireless router, and both machines are running Norton Anti-Virus 2006. I've added sqlserver.exe and sqlbrowser.exe to the exceptions list for the Worm protection on the laptop, i.e., the server machine. There's not a setting at the router that would prevent the server from re-starting, is there?

Any help is GREATLY appreciated!

Matt

View 15 Replies View Related

How To Configure SQL Server 2005 To Allow Remote Connections From Dos Command

Nov 13, 2007

Hi

As you know SQL Express by deefault accepts only local connections

For a particular requirement i have to change SQL Server Surface Area Configuration to accept remote connections by dos command
Anyone know this command?
thanks
Marco

View 16 Replies View Related

Unable To Configure Database Setup In Reporting Service 2005

Apr 29, 2008



Hi,

I have installed SQL Reporting Service on one server. Using the config tool, I am trying to setup the Reporting Database on a seperate SQL instance. This SQL instance is running on a Clustered SQL 2005 server.

The creation of the Database is sucessful. However when I give the Windows credentials to connect to this database on the same page, I always fail at the following task : Setting Connection Info for Reporting Server. The error message is :

"System.Runtime.InteropServices.COMException (0x800706B3)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.Get()
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetDatabaseConnection(String server, String database, ConfigurationCredentialsType credsType, String userName, String password)"

The Windows Account I am using has Full SQL Rights to the Clustered SQL Server. I have seen other posts on the forums about the 0x800706B3 error, but most of them are related to a problem with RPC.

The Reporting Services account is runing under 'Network Services'. I am not sure if this is causing the problem?

Thoughts anybody?

Thanks,

Mahmood




View 8 Replies View Related

Trying To Configure Reporting Services SQL 2005 On Windows 2008 Server With IIS7

Apr 21, 2008

Hi,
I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:

Report Server Virtual dir: ReportServer Default Web Site
Report Manager Virtual dir: Reports Defualt Web Site
Windows Service Identity: ReportServer with a service acct login
Web Service Identity:
Report Server: ReportServer,
Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.

When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:

"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".

I have read up on IIS7 and it says that:
"This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."

So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?

Thanks!
Isabelle

View 3 Replies View Related

Configure Data Source Insertion Into SQL Server 2005 Database - Express Editions

Sep 12, 2006

I am attempting to insert information from Visual Web Developer 2005 using either the Gridview or Datalist controls into a SQL Server 2005 database and get stuck when defining the custom statement.When I enter the text within the insert tab, the <next> button remains greyed out, preventing me from continuing to the next page.If I copy the same text into the select tab, then I can continue with the wizard, however this raises other problems which may or may not be related (multiple insertions of the data into the SQL Server database table - possibly due to postback functions). I would rather use insert to confirm that my second problem is not because I am using the wrong option.My question is:Should I be able to use the insert function within VWD express or is this only available within the standard/pro editions?

View 2 Replies View Related

How To Configure Distributed Transaction / XA Support Using Microsoft SQL Server 2005 JDBC Driver.

May 30, 2007

I am trying to configure distributed transaction and XA support using Microsoft SQL Server 2005 JDBC Driver. I have coppied SQLJDBC_XA.dll from XA directory and placed in my sql server binn directory and trying to run the script xa_install.sql from binn directory with command as below :

C:Program FilesMicrosoft SQL Server80ToolsBinn>
osql -U sa -n -P admin -S localhost -i C:JavaLibrariesMS SQL Driversqljdbc_1.2enuxa xa_install.sql

But I am getting error saying :
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

when I replaced local host with the machine name it gives error :
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

where in I am able to test connection from Websphere using the same connection.

Please help some one ....... I am in URGENT need.... I need to enable XA suport for my application to run........

Thanks ----

View 2 Replies View Related

How Do I Configure SQL Server 2005 Reporting Services To Deliver Subscription E-mails To Addresses External To My Windows Domain

Jun 10, 2007

Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?

I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.

For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.

Any insights?

View 1 Replies View Related

How To Configure SQL Server Management Studio Express To Allow Doing Non-User-Instance/ADO.NET 2.0 From VB 2005 Express?

Mar 5, 2008

Hi all,

For the first time, I want to set up the configuration of my SQL Server Management Studio Express (SSMSE) to allow me in doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. The SSMSE and VB 2005 Express are in my Windows XP Pro PC that is part of our NT 4 LAN System in our office. I read the article "How to configure SQL Server 2005 to allow remotre connections" in http://support.microsoft.com/kb/914277/ about (i) "Enable remote connections for SQL Server 2005 Express", (ii) Enable the SQL Server Browser service", (iii) Create exception in Windows Firewall, and (iv) Create an exception for the SQL Server Browser service in Windows Firewall. I entered the SQL Server Surface Area Configuration and I could not decide what options I should take for doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. I have the following questions on the page of "Minimize SQL Server 2005 Surface Area":
(1) I saw "Configure Surface Area for localhost [change computer]". I clicked on [change computer] and I saw the
following: Select Computer
The Surface Area Configuration of this surface area of this computer or a remote computer.
Specify a computer to configure: O Local computer
O Remote computer
Should I choose the "Local computer" or the "Remote computer" option?
(2) Below the "Configure Surface Area for localhost [change computer]",
I clicked on "Surface Area Configuration for Service and Connections", Select a component and then configure its services and connections: |-| SQLEXPRESS
|-| Database Engine
Service
I picked => Remote Connection
On the right-hand side, there are: O Local connections only
O Local and remorte connections
O Using TCP/IP
O Using named pipes only
O Using both TCP/IP and named pipes
Should I choose O Local and remorte connections and O Using named pipes only?

Please help and tell me what options I should choose in (1) and (2).

Thanks in advance,
Scott Chang

View 10 Replies View Related

How Do I Configure My Isa Server In Sbs 2003 To Allow Remote Connections For Sql Server 2005

Apr 19, 2008



hi,

could anyone guide me on how to allow, ceate rule for sql server 2005 remote connections to work. i already configured my sql server to allow remote connections and also my router, it is only in isa that is blocking the connections.


thanks

View 1 Replies View Related

Filegroups

May 25, 2000

I was told to move tables to new filegroups by placing the clustered index on the filegroup and the table would
follow. There are times when I see tables listed on the new filegroup but still listed also on Primary. My goal is
to have only system tables on Primary. How can I get a table to totally leave the PRIMARY group?

There seems to be a system index on the table that was not created by me.

View 1 Replies View Related

FileGroups

Jan 23, 2001

I have databse that was created when I got here and the database was created with 3 file groups. The tables in the database are spread out over the 3 file groups.

How can I find out which table belongs to which file group.

Thank You,
John

View 1 Replies View Related

FileGroups

Oct 8, 1999

If I'm running RAID 5, is it still good practice to split system and user data onto separate filegroups ? .....

On separate disks ?

Thanks in advance..
Any comments welcome ! Peter

View 1 Replies View Related







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