Viewing 15 posts - 7,996 through 8,010 (of 9,241 total)
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
you normally need to set DCOM permissions, have you done this yet
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 10:02 am
to give permissions to all tables and views use the roles
DB_Datareader
DB_Datawriter
or just create scripts to grant the permissions to the tables (remove un needed permissions as required)
GRANT SELECT, INSERT, DELETE,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 9:44 am
Truncate is generally more efiicient when clearing the whole table and unlike delete will reset any seed value as well!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 9:40 am
Viewing 15 posts - 7,996 through 8,010 (of 9,241 total)