Viewing 15 posts - 6,751 through 6,765 (of 9,253 total)
MAK1 (8/25/2011)
Thanks for help but I am getting following syntax errorGRANT CONNECT ON ENDPOINT: [Mirroring] TO [XXXXX\XXXXXX]
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ENDPOINT:'.
Sorry my bad...
August 25, 2011 at 9:22 am
as i said, this is not how you change it
MAK1 (8/25/2011)
ALTER ENDPOINT [Mirroring]AUTHORIZATION [XXXXXX\XXXXXX]
Create the login on each instance and grant connect to the mirror endpoint
CREATE LOGIN [Mydomain\UncleBobCobbly] FROM...
August 25, 2011 at 8:52 am
MAK1 (8/25/2011)
ALTER ENDPOINT [Mirroring]
AUTHORIZATION [XXXXXX\XXXXXX]
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near...
August 25, 2011 at 8:25 am
abdul.irfan2 (8/25/2011)
"2. UDP remote port 1434 is not set as an inbound rule on the client...
August 25, 2011 at 7:19 am
forsqlserver (8/25/2011)
The link is not opening.Atleast tell yes or No if confirm
the link opens fine for me, what browser are you using?
August 25, 2011 at 4:31 am
either a database owner or a sysadmin can change this, how many people hold this role in your organisation?
The state change is logged in the default trace so try having...
August 25, 2011 at 4:01 am
arie01 (8/24/2011)
August 25, 2011 at 2:19 am
It depends on lots of factors, for instance what location will be used for the primary server backups, a share on the primary server or a network location?
If you set...
August 25, 2011 at 2:03 am
its a very popular\stable forum, you just need a webserver with support for active server pages 😉
August 24, 2011 at 3:53 pm
Dj463 (8/24/2011)
No the server is not a part of windows cluster.
so how do you plan to install a clustered instance of SQL Server if the server is not part of...
August 24, 2011 at 3:02 pm
yes, use a database role and grant users access to the role
August 24, 2011 at 3:00 pm
flora M (8/24/2011)
Thanks for all the responses. I'll look for an option to do this from a stored procedure.
why??
August 24, 2011 at 2:55 pm
Snitz forum is a good way of creating an issues forum\tracker
August 24, 2011 at 2:52 pm
in truth, to SSRS, they are system databases. They hold metadata and temporary storage (sort of like a TEMPDB) used by the reporting services instance(s)
August 24, 2011 at 2:42 pm
flora M (8/24/2011)
[font="Courier New"]CREATE VIEW...
August 24, 2011 at 2:38 pm
Viewing 15 posts - 6,751 through 6,765 (of 9,253 total)