Viewing 15 posts - 7,996 through 8,010 (of 9,244 total)
if you're referring to SQL server resources then no, set up should do all that for you?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 5:00 am
check the event logs and post back the error message produced when trying to start the service. Most likely the log is corrupt so will need restoring or resetting!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2010 at 4:58 am
Maninder S. (4/30/2010)
you can even do something like this:SELECT 'GRANT SELECT ON '+quotename(table_name)+' to '+'Maninder' FROM Information_Schema.Tables
WHERE Table_Type='BASE TABLE'
don't forget to include the schema and use
SELECT'GRANT SELECT ON [' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2010 at 1:45 pm
Ratheesh.K.Nair (4/30/2010)
no use perry ..its still the same.
sorry, yes on the 2008 sql instance builtin admins group is no longer provisioned into sql server, but on the sql 2005 instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2010 at 1:36 pm
Brandie Tarvin (4/30/2010)
manoj2001 (7/9/2009)
enterprise manager and create and register new instance by giving name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2010 at 1:32 pm
AppemanKotze (4/30/2010)
I have a different problem. When i run the installer again i never get an option for creating a new instance. (i'm installing entaprise edition)
what do you see when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2010 at 4:08 am
pop your windows account into the local administrators group on that server and then check the results
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2010 at 4:06 am
Apurva (4/29/2010)
Quest Spotlight or Idera diagnostic manager
These products are primarily diagnostic products!
If you have SCOM installed I would use currently available or create your own managements packs and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2010 at 8:30 am
Lynn Pettis (4/29/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2010 at 8:26 am
Ratheesh.K.Nair (4/29/2010)
When i connected to a remote sql server ..the status icon(green for running & red for stopped) is showing blank its just white there for sql server and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2010 at 8:21 am
Hi
ok just thought i'd check. Incidentally, the best way there is to grant the distributed com users group remote access permissions and then add any users\groups ino this local group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2010 at 8:14 am
CirquedeSQLeil (4/28/2010)
The best way is to grant the permissions to a user role. Add the user or group to that role.
TO user_or_role
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2010 at 12:25 am
no going by the link, i always prefer a clean install and not an upgrade. Maintenance plans are stored in the msdb so wont be affected. Do you actually have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 10:54 am
personally i would uninstall ssis from node 1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 10:30 am
ico-601891 (4/20/2010)
The DOMAIN\USER is DOMAIN\GROUP member, and for this DOMAIN\USER is a domain administrator.
At the same time i add both DOMAIN\GROUP and DOMAIN\USER as member...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 10:22 am
Viewing 15 posts - 7,996 through 8,010 (of 9,244 total)