Shared SCSI Setup...
Jan 12, 2004
Ok, got an assignment from my boss.. Need shared storage for a 2 node cluster, with main focus on MSSQL DB Failover. We won't be storing alot of data, speed it not really an issue, just availability..
As far as I know I need 2 SCSI cards, 1 for each node. Node1 has to have ID7 and Node2 ID6 (for example)
this is it.. what's next? what's the best way to configure all this? Do I need a special box for all hard drives to be with certain controller?
I was thinking to link up like this
terminator
|
Node1
|
|
Disk
|
|
Node2
|
terminator
But I wanted to run some sort of RAID on disk, mirroring is fine.. Anyone can suggest me what parts I should get for this setup? my servers don't have 64bit PCI too
View 1 Replies
ADVERTISEMENT
Mar 10, 2004
I appologize if I am posting this msg twice (newby), but I am getting this error msg in the app log.
MS DTC setup failed to populate the shared cluster
registry. The DTC resource will not be able to come
online.Error Specifics:
d:srv03rtmcomcomplusdtcsharedmtxclumtxcluse
tuphelper
.cpp:120, CmdLine: "C:WINDOWScluster
esrcmon.exe" -e
1208 -m 1212 -p 2132, Pid: 3636
Have anybody seen this msg and any ideas on what to do in this situation? Your timely assistance is much appreciated. Thanks,
View 5 Replies
View Related
Jul 20, 2005
Dear Friends,I wanted to configure Failover cluster for SQL Server 2000 on Windows2000 advanced servers.I have only 2 no.s of windows 2000 advanced server m/cs. I dont haveany shared disks and SCSI drives. Can I still configure the Failoverclustering?I would like to know more about the need for the shared disks in theFailover clustering.Please shed some light.RegardsKumar
View 1 Replies
View Related
Feb 14, 2006
I have a guy who wants me to move his databases to an external drive. Hardware is my major weakness and I usually think I am McGyver when I can swap out a RAM board in my home PC. Whenever guys in the office start talking hardware, I go hide in the bathroom.
I know I have read that this is a very bad idea in some book and a few message board threads. This guy is going to use SCSI and it is going to be attached to the same controller as his other disks. I know he should have a battery backup for the drive especially if it employs write caching and that it should be formatted to NTFS and not FAT32.
I googled echnettedBOLedMSDNed this for 2 hours yesterday because I remember reading something about disc controllers and external drives and SQL Server being a recipe for disaster but I could not find anything to back me up.
Any words of wisdom or advice?
View 2 Replies
View Related
Jan 5, 2006
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
View 12 Replies
View Related
Jul 23, 2015
We're doing upgrades from SQL 2008 R2 to SQL 2014. This is blocked due to RS is installed but not configured. Our desired action is to uninstall RS and proceed with the upgrade. But when setuparp.exe is raised, it does not list all the features on the 'Select Features' page. In fact, it only lists the last 2 shared features (SQ Client Connectivity SDK and Microsoft Sync Framework). However, all items appear to be listed on the 'Select Instance' page including RS. I've seen this issue on 2 of our SQL 2008 R2 Servers already.
View 3 Replies
View Related
Nov 15, 2015
I'm trying to install SQL Server Management studio 2012 on my Windows 7 (x64) standalone laptop. When I click "New SQL stand-alone installation..." it runs a Setup Support Rules check and always fails "Setup Account Privileges". I've looked into the error and I keep getting that I need to change security rules but I don't have that option in window 7. How do I get around this without having to resort to a computer running Windows Server?
I have Visual Studio 2013 premium installed along with Localdb v11. I just want to connect and manage my database engine through SSMS when developing any application.
View 2 Replies
View Related
Nov 17, 2005
This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.
Thanks
View 11 Replies
View Related
Apr 24, 2015
I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:
MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2
If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.
View 3 Replies
View Related
May 11, 2000
Hi,
I have a shared drive mapped to the h: drive letter on my sql server and I want to create new databases on that drive. Is this at all
possible?
I try it and I couldn't see h: even if I typed it in.
Thanks
View 2 Replies
View Related
Feb 16, 2008
Hello
Maybe someone can suggest me some software which can be used for SQL 2005 shared hosting?
With database size limit, user number restriction and other features.
Thank you for information in advance
View 3 Replies
View Related
Apr 9, 2008
I am new to reporting services, working with RS2000. Roles and security have previously been set up.
Shared Datasources have been created. How is access granted to shared datasources?
Some users have access but we haven't been able to create new users with access to the shared datasources.
Thanks
View 1 Replies
View Related
Mar 6, 2007
Hi,
I am trying to use shared variables in the emebedded code of a report. But
when i assign a value to the shared variable in the detail level and access
the same from footer it shows different value (0).
I declared an integer variable as a shared variable. And changed its value
in the detail level. Then tried to access its value in the table footer.
Public Shared testVal As Integer
Function testValFunc()
testVale = 25
End Function
In detail level i call Code.testValFunc()
In footer -> Code.testValFunc() gives 0
Any Idea??? Is it because the header/footer is computed first and then the detail?
-
HelpSeeker
View 1 Replies
View Related
Jul 11, 2006
Exit it in sqlserver notion of shared connection or dedicaced connection like there is exist in oracle ?
Exit it a part of memory (like PGA in oracle) who exist just for the connections ?
Else what are constitued the memory in sqlserver ?
Thanks
View 1 Replies
View Related
Mar 25, 2004
Hi,
I have noticed the the cubes that we have here use shared dimensions.
For almost all cubes(5-6) there are at least 4-5 common dimensions.
According to what I have been preached so far, the shared dimensions are so that you can reuse them. That is not what is practised here.
for example.
cube1 has somedim1, dim2_c1, dim3_c1...
cube2 has xyzdim1_c2,xyzdim2_c2,dim3_c2..
dim3_c1 and dim3_c2 are the same dimensions, one for each cube.
I don't know if I am missing something. Shouldn't the use the same dimensions? Could there be any reason for this.
pls. advice.
TIA
View 3 Replies
View Related
Apr 21, 2008
Hello,
Here's my problem :
I have several packages, one parents and several childs.
I want to define just one connexion for all theses packages, so I used a Data source. But I had several problem with that object.
So I'm looking for the best way to define one working database connexion for all my packages.
Can someone help me ?
Thanks in advance.
View 2 Replies
View Related
Apr 5, 2007
HI,
currently two people(with different username and password) are using a shared workstation, where in the sql server is installed. so i just wanted to know that whether two people could use the sql server at the same time. please note that the two people have different username and password to enter to log in.
Thanks,
Nitin
View 2 Replies
View Related
Jul 20, 2005
We've been running a database on a shared server. The traffic on oursite has been picking up steadily and it seems as though we're runninginto sporadic downtime on the database. Sometimes when we do largedata imports, the transaction log fills up and the schema somehowfails to truncate it when asked to back it up. So we run the explicittruncate statement and that usually seems to fix the problem. A fewdays ago a single stored procedure started to block, but inexplicablyonly when called by our .NET server. When called by hand fromEnterprise Manager, it executed fine. I was at my wits end when Ijust recreated it with the same exact code and it magically startedworking again. What gives? Is this at all indicative of a shareddatabase, or are these known SQL Server issues?
View 4 Replies
View Related
Jul 20, 2005
I am new to setting up SQL Server and would greatly appreciate ifsomeone can help me out with this issue:I have successfully set up SQL Server but want to be able for clientsof mine to be able to connect to it via the web through enterprisemanager. I have tried everything I could think of to get it to work. Imade sure the correct ports where open in the firewall (1433,1434).Everytime I try to connecting using the IP of the box that the SQLServer resides I get SQL Server does not exist or access denied. Iverified that the login credentials being used for the database I amtrying to correct to are correct. Still the same error message.How I would like to set it up would be to create a subdomain on thebox and point it to SQL Server so that is what would be entered whenregistering the group in enterprise manager.I am currently running all my sites through vhost on a single IP usingIIS 2003. SQL Server is installed on the box where all of the sitesare being served up.Is it impossible to set-up SQL Server to allow connections over theweb when using a Shared IP?I have been researching this for over a week now and hope someone outthere can help me.Thanks in advance!!
View 3 Replies
View Related
Feb 2, 2007
I have a couple of questions on the nature of shared and private deployment of SQL Server CE 2005 on mobile devices:
1. I've read that with a shared install, SQL Server 2005 Compact Edition files are automatically updated and serviced by Microsoft Update. I take it that this only applies to installations on desktop computers -- if you're installing on mobile devices, there IS no automatic update. Right?
2. I've also read that in order to do a shared install of SQL Server 2005 CE, the user must have administrative rights. How does this apply to installs on a mobile device? There is no such thing as an administrative user on a mobile device. However, mobile devices CAN require different levels of privilege to install certain programs -- do you need something like an application signed for privileged execution (via a M2M certificate) in order to do a shared install of SQL Server 2005 CE on a mobile device?
Or is the shared versus private deployment only an issue when deploying to a desktop?
Larry
View 4 Replies
View Related
Sep 25, 2007
Hi,
Is there a way to display only the shared schedule option in the subscription page? in other words, can the manual scheduling be hidden?
Thank you.
View 3 Replies
View Related
Dec 19, 2006
I experimented a strange behavior using connections for data source inside packages in vss 2005.
Suppose we have a tab1 in a develpment source db and in a test source db:
tab1 dev db contains 100 records
tab 2 test db contains 200 records
I start developing a package using an 'ole db data source' task inside a data flow. When I change the data source from dev to test, strange thinks happens.
The 'ole db source task' retrieve only 197 records ... but if I open the connection inside the connection manager pane and only after i click on the 'test connection' button tI get 200 records.
The source db is a sql 2000 db server and I use ole db provider for sql server.
Cosimo
View 1 Replies
View Related
Mar 10, 2006
I have created a few packages which uses shared 2 data sources called source and desitination. When i change the server in the datasource file
manuallyprogramatically, it is not reflecting in all the packages. Ideally all the packages should refer to this shared datasource,but i found out that the server name is hardcoded in each and every package which destroyes the concept of shared data sources in SSIS packages.How ever if i change the server name in the data source from the SSIS environment itself then all packages using the shared datasource are updated.Is there a work around for this apart from changing the server in every package.
View 3 Replies
View Related
Oct 10, 2007
Hi All,
I need a report to execute every 5 minutes on every week day and I am trying to do this using a shared schedule.
I had looked all the options available with Shared Schedule and looks like there is no way to do this.
Please let me know if you have a work around.
Thanks,
Prakash.P
View 1 Replies
View Related
Mar 13, 2007
Is it possible to create a datasource, which is not at al shared via vs 2005
View 1 Replies
View Related
Feb 3, 2006
Anyone know what or how to calculate how much bandwidth I may use during replication. I have done this with large pipes with out a problem, just concerned I may need to change the interval to something else.
Thanks
JJ
View 1 Replies
View Related
Apr 7, 2007
Using Vista, when I start Outlook 2007 I get the following message:
Business Contact Manager for Outlook could not connect to the shared database.//looking for msslbiz Do you want to work offline?
I click Continue and get the messagebox:
Business Contact Managerdatabase cannot be loaded
This action cannot be completed because Business Contact Manager cannot access the database. The database is currently stopped.
Do you want to change the database configuration?
i say Yes and the messagebox says
Microsoft Windows Search Protocol Host has stopped working.
A problem cause the program to stop working correctly. Windows will close the program and notify you if a solution is available.
I close program (no choice) and message says:
Cannot find the selected database. Verify that the network and the computer on which the databases are located are available, and that you have permission to access the database, and then retry.
Connect to computer name prompt does not work
Create new database does not work
Database creation was unsuccesful
Using MS SQL Server Management Studio Express) to connect to msslbiz
SQLServer does not allow remote connections (when trying to conect to
Note that SqlServer Express is started and running on the Vista machine, and the databases I create are available to other machines on my lan. I cannot find a way to enable remote connections on msslbiz. Any help would be greatly appreciated.
View 5 Replies
View Related
Jul 16, 2007
Hi all,
Ive tried searching but nothing came up specific to my problem.
I currently have all the reports separated into separate folders, such as Finance, HR etc, and the datasources in a datasources folder at the root level. My problem is that when i upload reports into their appropriate folder, the shared datasource information gets deleted, and i need to re-map it everytime.
Is there anyway to have the specific reports point to specific shared datasource folders on the report server when i upload them?
cheers
Rob.
View 1 Replies
View Related
Oct 20, 2007
Hi,
We are using Shared Schedule to trigger reports at a particular time. We are invoking the SQL Job associated with the shared schedule. How to identify when the shared schedule gets completed i.e. all the associated reports with the shared schedule are generated. We need to trigger other external processes once all the reports are generated. Kindly help me in this.
Subash
View 3 Replies
View Related
Aug 18, 2006
Hello, I am wondering how to code asp.net to prevent multiuser from modifying a share data (on sql server) at the same time.
View 1 Replies
View Related
Jan 4, 2007
Hi guys, I hope this is the correct place to post this question. 1) My website makes use of the Membership and Roles of asp.net 2. 2) I have uploaded my website to a shared hosting server, which doesn't support sql express (mdf files). It does support mysql, so I used a custom Membership provider for MySql. 3) It worked greate on my local computer, however (!!) it still creates a aspnetbd.mdf file in the AppData folder. 4) Obviously, when I tried to run it on the website, I got an error. My questions: Why my website still creates a aspnetbd.mdf file even if I am not using it anymore for the Membership ? How can I disable it, in order for it to run on a server which does not support it ? Thanks, Itye.
View 1 Replies
View Related
Jan 16, 2006
I've created a new website using the new Visual Studio 2005 Express edition. This site uses SQL Server Express (free software) as a storage for personalization data, etc. Now I want to deploy my site, but here it ends for me:My web site hoster does not support the SQL Express edition in a shared hosting environment. I think most people have a website running in a 'shared hosting' plan. How can this large group enjoy the new Express line when SQL Server Express is not supported? "SQL Server Express is not a part of the SPLA SPUR (Services Provider License Agreement)", they all say. Here it ends for me, my ISP and their licence supplier. Even at Microsoft's Response Management Team, 'no' is the answer.
What to do now? Move on to an expensive 'dedicated hosting' plan? Write a membershipprovider for MySQL?I feel as if I was given a free ticket for a nice journey but there's no traffic possible.
Who can help me out here? What can I do...
View 15 Replies
View Related
May 1, 2006
All--
Please help.
I have deployed my site to my shared host and I am getting the following RTE...
An attempt to attach an auto-named database for file... ..App_DataCommerceDB.mdf failed
...and I cannot find the issue.
Note that I have given Full-Permissions on root folder for the IUSR account and for the ASPNET account.
The full error message is below.
Anyway, do you have an suggestions?
My web hosting provider has advertised that they do support SQL Express 2005. What exactly do I need to ask them to do in order to get this working?
Please advise.
Thank you.
--Mark Kamoski
Server Error in '/mkamoski/S16' Application. --------------------------------------------------------------------------------
An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 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 attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
Line 88: ''' <returns></returns>
Line 89: Public Shared Function GetCart() As ShoppingCart
Line 90: Dim rdr As IDataReader = ShoppingCartProvider.Instance.CartGetCurrentCart(GetUserName())
Line 91: Dim cart As ShoppingCart = New ShoppingCart()
Line 92: cart.Load(rdr)
Source File: c:hostingwebhost4lifemembermkamoskiS16App_CodeBLLShoppingCartManager.vb Line: 90
View 5 Replies
View Related
