filtering with set: installed

Showing posts with label installed. Show all posts

Thursday, March 29, 2012

Granting consultant access to database

Hi,
I need to grant a consultant access to one database on an sql server.
I do not want to give him remote access to the server.
I have installed the client tools (Enterprise manager) on his laptop.
I put him in Users and made him db_admin.
However, when he connects to the server and clicks on the tables it says he
is an invalid user error 916.
Any ideas how i can do this so its most secure. He needs to examine the
tables on the server. The SQL server is 2000.
ThanksRoberto,
Something that you might check. If you ran sp_grantdbaccess to make your
consultant a user in the database, that does not prove that he has access to
the server. You may also need to:
EXEC sp_grantlogin 'Corporate\BobTheConsultant'
If that is OK, then you should also check that the default database of his
login is a database to which he has access. The 'not a user' may come from
the default database.
RLF
"Roberto R" <RobertoR@.discussions.microsoft.com> wrote in message
news:BE654755-B958-48AB-9B5A-BCF215916729@.microsoft.com...
> Hi,
> I need to grant a consultant access to one database on an sql server.
> I do not want to give him remote access to the server.
> I have installed the client tools (Enterprise manager) on his laptop.
> I put him in Users and made him db_admin.
> However, when he connects to the server and clicks on the tables it says
> he
> is an invalid user error 916.
> Any ideas how i can do this so its most secure. He needs to examine the
> tables on the server. The SQL server is 2000.
> Thanks

Friday, March 23, 2012

Grant Database Access

I am setting up report services after I installed the report server add-ins
on sharepoint 2007.

at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.

at second step, Grant Database Access,
I put ssrsdev1 for server name (default instance) and then click OK and then
I put the user name (a member of local admin group on ssrsdev1) and password,
but I always got errors says:
Unable to log on with the given username and password.
what wrong here? what should I check? I am sure the user and password is
right and I can log on to ssrsdev1 physically with admin right without any
problem.
thanks for any thought on this.
zwp

Is SharePoint 2007 also installed on ssrsdev1?

If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?

thanx,
Prash

|||

we installed sharepoint 2007 bianry on ssrsdev1 (report server with sp2). and the user is a domain user and a member of local admin group. Actually, the report server, sql server and sharepoint all run under domain user (also a member of local admin group). When we tried to use user name domain\user and we got a error says: the group name can't find; when we use user or user@.domain.com to connect, we got the error I posted before. We tried to reinstall the sharepoint 2007 and still got same problem.

Thanks in advance for your help.

|||

In you care you should use <domain_name>\<user> format.

In any case, in "Grant Database Access" we essentially try to add the Reporting Services service accounts to the WSS_WPG windows group. The WSS_WPG windows group should have been created when you installed SharePoint.

Can you verfy whether ssrsdev1 has a WSS_WPG windows group?

thanx,
Prash

|||

the windows group are on both report servers (ssrsdev1 and it also is the content database server for sharepoint server) and sharepoint server (spserver). I have manually added the user account into this grouop in both server, but I still get the same error.

Actually, I installed and running everything (report server and its services, sql server, and sharepoint, etc.) with the same domain user which is a member of local admin group on both boxes, therefore, the user should have access to everything, but I don’t understand why I am still have the problem with ‘grant database access’. Is it a bug?

BTW, we use sharepoing 2007 and sp2 December 2006 CTP.

Thanks,

zwp

|||

I just posted a message. Sorry it was my bad. I might mistype something. It works now.

However, when I go to next step:

Set server defaults

I got error message:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?

BTW, in sp2 BOL, it says: Verify the installation

use this address:

http://example-server-name:8081/reportserver

the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else

thanks again.

zwp.

|||

http://example-server-name:<port>/reportserver

example-server-name = the server on which Report Server is installed

<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.

Hope this helps.

thanx,
Prash

|||

could someone let me know how to find user :'sharepoint\system' since I can't find it in computer manager. I bet it is a system account used by sharepoint but how to set the permission to it. I got following

The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation. > The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation.

when I at screen:

Reporting Services Server Defaults

thanks.

|||

Generally you should open another thread for a different issue.

In any case, are you able to upload / view reports in other SharePoint web sites?

Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?

thanx,
Prash

|||

Hi,

I've experienced the same problem.

In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:

The group name could not be found

In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul

My SQL server 2005 with SP 2 is installed in another server.

Any advice?

Paul

|||

The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.

HTH
Prash

|||

Thanks.

Actually, I can setup the SharePoint Integration in a single-box (MOSS+SQL). So, as you said, WSS_WPG is in the same machine. However, as my SQL server is installed in another server. What can I do? (I did create a group called WSS_WPG manually in the SQL server, but still failed)

Any idea?

Paul

|||

Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.

For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.

HTH
Prash

Grant Database Access

I am setting up report services after I installed the report server add-ins
on sharepoint 2007.

at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.

Is SharePoint 2007 also installed on ssrsdev1?

If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?

thanx,
Prash

|||

Thanks in advance for your help.

|||

In you care you should use <domain_name>\<user> format.

Can you verfy whether ssrsdev1 has a WSS_WPG windows group?

thanx,
Prash

|||

BTW, we use sharepoing 2007 and sp2 December 2006 CTP.

Thanks,

zwp

|||

I just posted a message. Sorry it was my bad. I might mistype something. It works now.

However, when I go to next step:

Set server defaults

I got error message:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?

BTW, in sp2 BOL, it says: Verify the installation

use this address:

http://example-server-name:8081/reportserver

the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else

thanks again.

zwp.

|||

http://example-server-name:<port>/reportserver

example-server-name = the server on which Report Server is installed

<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.

Hope this helps.

thanx,
Prash

|||

when I at screen:

Reporting Services Server Defaults

thanks.

|||

Generally you should open another thread for a different issue.

In any case, are you able to upload / view reports in other SharePoint web sites?

Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?

thanx,
Prash

|||

Hi,

I've experienced the same problem.

In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:

The group name could not be found

In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul

My SQL server 2005 with SP 2 is installed in another server.

Any advice?

Paul

|||

The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.

HTH
Prash

|||

Thanks.

Any idea?

Paul

|||

Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.

For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.

HTH
Prash

Monday, March 19, 2012

got a problem when try to connect to a sqlexpress database with c# desktop application,t hx a lo

hi experts,

I have sqlexpress installed, I can connect to it with my c# desktop application, connection string is:
"server= 192.168.0.3.\SQLEXPRESS,1921; user id='sa'; password='*****'; Database='EvoHealthSQLex'; Integrated Security=True"

as you can see 192.168.0.3 is that machine's (with sqlexpress installed) local Ip address, however I need to set it to be assessible through the Internet, so I set the port forwarding service in my router, so it's actually Ip address should be: 62.31.81.210 and I think it is working, as I can view the default website on that machine by typing in http://62.31.81.210/ in IE.

however, when I try to change the connectionstring of my c# app to :
"server= 62.31.81.210.\SQLEXPRESS,1921; user id='sa'; password='*****'; Database='EvoHealthSQLex'; Integrated Security=True"
then it's not working, whether I put the port number 1921 or not, it still working with that local Ip address 192.168.0.3 though

I wonder what is the correct way to make it accessible through Internet and what is the connection string gonna be?

Many thanks for reading my question!

ps: I saw below is a sqlexpress forum, but no post at all ?!

rayBristol,

This is a interesting scenario. "Port forwarding" should be transperant to sql connection. I guess you already made the port 1921 forwardable on your router.

To troubleshoot the connectivity,

1. Make sure the firewall is opened for port 1921 on hosting machine of the SQL Server.

2. Try "telnet 62.31.81.210 httpport (normally 80 or 8080)", and compare the result with "telnet 62.31.81.210 1921". If you can't connect for the later case, your configuration of port forward has issue. After connect, you can "ctrl+']' and quit for exit telnet.

3. Once you pass 2, if you still have troulbe connecting, you can post the errormsg and complete stack trace of your c# application when connection failes.

|||

HI, sorry I forgot to make port 1921 forwardable !

And now I did, and it works now!!!

but why you saying "Port forwarding" should be transperant to sql connection ? is that mean port forwarding has nothing to do with sql connection ?

Thanks very much for you help!!!

|||

"is that mean port forwarding has nothing to do with sql connection ?

Yes, except the port needs to be configured correctly.

|||

Hi, thanks so much for you help, now I can use either local Ip address or the router ip address for the connectionstring, however, I got another problem, sounds simple, I use another computer (within the same local network) run the same program, got a login failed error, after some googling, I added a user to that database with permission to connect, but same thing happened, I wonder if you can have a look if not too much trouble:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=288311&SiteID=1&mode=1

it looks pretty long as I put lots other detials try to make this question as clear as possible.

Many thanks again for your help!

Wednesday, March 7, 2012

Going From SQL Enterprise to SQL Standard

We mistakenly installed SQL Enterprise on a production server, and it should
've been SQL Standard. How can we go from Enterprise to Standard? Will we
have to move the database to a different SQL server, then uninstall SQL Ente
rprise and install SQL Stan
dard? Or, is there an easier way?Hi,
I feel that we can not come down from Enterprise to Standard, but the other
way is possible.
I think you may need to Reinstall standard edition and copy back the
databases. Please wait for 2 more days till all our experts confirm the
possibilities.
Incase if you need to reinstall then,
As a precausion take a backup of all databases
do
1. Stop current sql server service
2. Copy all mdf and ldf to a safe folder
3. Uninstall SQL server EE
4. nstall SQL server Standard and SP3a with same folder structure as old
5. Copy back the mdf and ldf files to same folders as old
6. start sql server.
Mostly the sql server will be up will all the databases, if not use the
backup files we backup to restore each databases.
Thanks
Hari
MCDBA
Thanks
Hri
MCDBA
"Mickey" <mmorris@.tacenergy.com> wrote in message
news:FFF4D5BD-1569-4FEB-988C-D2D9820E78AD@.microsoft.com...

quote:

> We mistakenly installed SQL Enterprise on a production server, and it

should've been SQL Standard. How can we go from Enterprise to Standard?
Will we have to move the database to a different SQL server, then uninstall
SQL Enterprise and install SQL Standard? Or, is there an easier way?|||Thanks Hari...I'll wait a couple more days and see. I appreciate the info.

Going From SQL Enterprise to SQL Standard

We mistakenly installed SQL Enterprise on a production server, and it should've been SQL Standard. How can we go from Enterprise to Standard? Will we have to move the database to a different SQL server, then uninstall SQL Enterprise and install SQL Standard? Or, is there an easier way?Hi,
I feel that we can not come down from Enterprise to Standard, but the other
way is possible.
I think you may need to Reinstall standard edition and copy back the
databases. Please wait for 2 more days till all our experts confirm the
possibilities.
Incase if you need to reinstall then,
As a precausion take a backup of all databases
do
1. Stop current sql server service
2. Copy all mdf and ldf to a safe folder
3. Uninstall SQL server EE
4. nstall SQL server Standard and SP3a with same folder structure as old
5. Copy back the mdf and ldf files to same folders as old
6. start sql server.
Mostly the sql server will be up will all the databases, if not use the
backup files we backup to restore each databases.
Thanks
Hari
MCDBA
Thanks
Hri
MCDBA
"Mickey" <mmorris@.tacenergy.com> wrote in message
news:FFF4D5BD-1569-4FEB-988C-D2D9820E78AD@.microsoft.com...
> We mistakenly installed SQL Enterprise on a production server, and it
should've been SQL Standard. How can we go from Enterprise to Standard?
Will we have to move the database to a different SQL server, then uninstall
SQL Enterprise and install SQL Standard? Or, is there an easier way?

Going from Express to SQL 2005 Standard

I have used VWD and SQL Express with success. Now I have uninstalled SQL Express and installed SQL Server 2005 Standard along with Visual Studio 2005 Standard editions. The problem that I am having is when I go to use the ASP .Net configuration tool, it cannot connect to the new instance.

Now I did run the aspnet_regsql utility to create the membership tables.

Did I do something wrong in the setup of the new SQL Server 2005? I have been trying to get an answer and find an answer to this problem for 2 days now.

Thanks for any help.

Have you posted this on the ASP.Net forums? (http://forums.asp.net/146/ShowForum.aspx)

What is the specific error message you are seeing?

|||I have posted it to ASP .Net forums and have not got an answer. I did find out the answer this weekend though. It was something in the web.config file that was note properly syntaxed.

Thanks.

Going back to SQL Server 7...

Hi there! I have a PC with Windows XP Pro installed. I have it also with
SQL Server 2000. I'd like to install back SQL Server 7, but I keep getting
an error that Enterprise Manager.msc can't be installed.
Could someone shed some light on this? What are the steps I must take in
order to install SQL 7 (previous version).
Thanks for your time,
FelixI believe that SQL Server 7.0 would have to be installed first, and then SQL
Server 2000 could be installed as a separate instance -- SQL Server 7.0 is
not instance-aware, so I doubt it can be installed second.
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
> Hi there! I have a PC with Windows XP Pro installed. I have it also with
> SQL Server 2000. I'd like to install back SQL Server 7, but I keep
getting
> an error that Enterprise Manager.msc can't be installed.
> Could someone shed some light on this? What are the steps I must take in
> order to install SQL 7 (previous version).
> Thanks for your time,
> Felix
>
>|||Adam,
In other words, does this mean that I must reformat my PC?
Thanks for your time,
Felix
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
>I believe that SQL Server 7.0 would have to be installed first, and then
>SQL
> Server 2000 could be installed as a separate instance -- SQL Server 7.0 is
> not instance-aware, so I doubt it can be installed second.
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
> news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
>> Hi there! I have a PC with Windows XP Pro installed. I have it also
>> with
>> SQL Server 2000. I'd like to install back SQL Server 7, but I keep
> getting
>> an error that Enterprise Manager.msc can't be installed.
>> Could someone shed some light on this? What are the steps I must take in
>> order to install SQL 7 (previous version).
>> Thanks for your time,
>> Felix
>>
>|||No, absolutely not. What it means is that you might have to un-install SQL
Server 2000, then install SQL Server 7.0, then install SQL Server 7.0 SP4,
then re-install SQL Server 2000 and update to SP4. You can detach and back
up all of your databases first, then re-attach them when you're back up and
running.
Another option might be to use a Virtual PC for the SQL Server 7.0
installation. Have you considered that?
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
news:%239r0roOcFHA.2980@.TK2MSFTNGP10.phx.gbl...
> Adam,
> In other words, does this mean that I must reformat my PC?
> Thanks for your time,
> Felix
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
> mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
> >I believe that SQL Server 7.0 would have to be installed first, and then
> >SQL
> > Server 2000 could be installed as a separate instance -- SQL Server 7.0
is
> > not instance-aware, so I doubt it can be installed second.
> >
> > --
> > Adam Machanic
> > SQL Server MVP
> > http://www.datamanipulation.net
> > --
> >
> >
> > "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
> > news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
> >> Hi there! I have a PC with Windows XP Pro installed. I have it also
> >> with
> >> SQL Server 2000. I'd like to install back SQL Server 7, but I keep
> > getting
> >> an error that Enterprise Manager.msc can't be installed.
> >>
> >> Could someone shed some light on this? What are the steps I must take
in
> >> order to install SQL 7 (previous version).
> >>
> >> Thanks for your time,
> >> Felix
> >>
> >>
> >>
> >
> >
>|||Félix,
You shouldn't need to format the machine. Delete everything from
c:\program files\Microsoft SQL Server. Delete everything in MSSQL7
directoy. Then go to the registry and remove everything relating to SQL
Server in there.
Reformatting your machine is an extreme measure, unless you have an
autobuild disk, and you can put it in while you go and have lunch... ;-)
See this article before you do anything:
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/?id=290991
The article applies to SQL2000, but the same principles apply to SQL7.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Félix Meléndez wrote:
> Adam,
> In other words, does this mean that I must reformat my PC?
> Thanks for your time,
> Felix
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
> mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
>>I believe that SQL Server 7.0 would have to be installed first, and then
>>SQL
>>Server 2000 could be installed as a separate instance -- SQL Server 7.0 is
>>not instance-aware, so I doubt it can be installed second.
>>--
>>Adam Machanic
>>SQL Server MVP
>>http://www.datamanipulation.net
>>--
>>
>>"Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>>news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
>>Hi there! I have a PC with Windows XP Pro installed. I have it also
>>with
>>SQL Server 2000. I'd like to install back SQL Server 7, but I keep
>>getting
>>an error that Enterprise Manager.msc can't be installed.
>>Could someone shed some light on this? What are the steps I must take in
>>order to install SQL 7 (previous version).
>>Thanks for your time,
>>Felix
>>
>>
>|||Mark,
Thanks a lot for your time and patience. I'll print and read the article
you state below.
On the other hand, before turning to the newsgroups, I indeed uninstalled
SQL Server 2000 and then tried installing back again SQL Server 7.0. But I
do not know why I began getting an error about "Enterprise Manager.msc" not
being configured correctly. As soon as I clicked on the OK, button, the
whole installation rolled back. Maybe I overlooked a step I had to take
(since I did not know about the article). I'll try to do it again... this
time following your advice.
Thanks again for your support.
Félix
"Mark Allison" <mark@.no.tinned.meat.mvps.org> escribió en el mensaje
news:e32R1yOcFHA.4048@.TK2MSFTNGP10.phx.gbl...
> Félix,
> You shouldn't need to format the machine. Delete everything from
> c:\program files\Microsoft SQL Server. Delete everything in MSSQL7
> directoy. Then go to the registry and remove everything relating to SQL
> Server in there.
> Reformatting your machine is an extreme measure, unless you have an
> autobuild disk, and you can put it in while you go and have lunch... ;-)
> See this article before you do anything:
> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/?id=290991
> The article applies to SQL2000, but the same principles apply to SQL7.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Félix Meléndez wrote:
>> Adam,
>> In other words, does this mean that I must reformat my PC?
>> Thanks for your time,
>> Felix
>> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
>> mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
>>I believe that SQL Server 7.0 would have to be installed first, and then
>>SQL
>>Server 2000 could be installed as a separate instance -- SQL Server 7.0
>>is
>>not instance-aware, so I doubt it can be installed second.
>>--
>>Adam Machanic
>>SQL Server MVP
>>http://www.datamanipulation.net
>>--
>>
>>"Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>>news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
>>Hi there! I have a PC with Windows XP Pro installed. I have it also
>>with
>>SQL Server 2000. I'd like to install back SQL Server 7, but I keep
>>getting
>>an error that Enterprise Manager.msc can't be installed.
>>Could someone shed some light on this? What are the steps I must take in
>>order to install SQL 7 (previous version).
>>Thanks for your time,
>>Felix
>>
>>
>>|||Adam,
Thanks also a lot for your time and patience.
On the other hand, before turning to the newsgroups, I indeed uninstalled
SQL Server 2000 and then tried installing back again SQL Server 7.0. But I
do not know why I began getting an error about "Enterprise Manager.msc" not
being configured correctly. As soon as I clicked on the OK, button, the
whole installation rolled back.
Mark Allison also states that I should read the article about "Uninstalling
SQL Server 2000...".
I'll try to do it again... this time following both of your advices.
Thanks again for your support.
Félix
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
mensaje news:udgUnwOcFHA.3488@.tk2msftngp13.phx.gbl...
> No, absolutely not. What it means is that you might have to un-install
> SQL
> Server 2000, then install SQL Server 7.0, then install SQL Server 7.0 SP4,
> then re-install SQL Server 2000 and update to SP4. You can detach and
> back
> up all of your databases first, then re-attach them when you're back up
> and
> running.
> Another option might be to use a Virtual PC for the SQL Server 7.0
> installation. Have you considered that?
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
> news:%239r0roOcFHA.2980@.TK2MSFTNGP10.phx.gbl...
>> Adam,
>> In other words, does this mean that I must reformat my PC?
>> Thanks for your time,
>> Felix
>> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
>> mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
>> >I believe that SQL Server 7.0 would have to be installed first, and then
>> >SQL
>> > Server 2000 could be installed as a separate instance -- SQL Server 7.0
> is
>> > not instance-aware, so I doubt it can be installed second.
>> >
>> > --
>> > Adam Machanic
>> > SQL Server MVP
>> > http://www.datamanipulation.net
>> > --
>> >
>> >
>> > "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>> > news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
>> >> Hi there! I have a PC with Windows XP Pro installed. I have it also
>> >> with
>> >> SQL Server 2000. I'd like to install back SQL Server 7, but I keep
>> > getting
>> >> an error that Enterprise Manager.msc can't be installed.
>> >>
>> >> Could someone shed some light on this? What are the steps I must take
> in
>> >> order to install SQL 7 (previous version).
>> >>
>> >> Thanks for your time,
>> >> Felix
>> >>
>> >>
>> >>
>> >
>> >
>>
>|||Adam,
I don't want to seem I'm buggy, but... before trying to uninstall SQL Server
2000, please let me try to explain where this story all begins...
At work, we have some customers from outside the country. First I had in my
PC installed SQL Server 7.0 with Windows 2000 Professional. We currently
have a webserver with Windows 2000 Advanced Server with SQL Server 7.0. In
that server, we have some databases. As I was telling you, customers from
outside the country had access to this web server to run some web
applications. Since I develop such web applications from my PC, once I
develop something new or update some functionality, I have to copy the new
webpages or edited webpages back to the server as well as run some sql
scripts in order to update the database. I also have to reinstall the DLL
(data & business logic) in Component Services. After a while, I found out an
article about a configuration file that could be configured to point to a
test (my PC) or production (Server) database. I implemented this
configuration file with no hassle. Once in production, this configuration
file helped me to update just the webpages as well as the DLL, because this
time the user (transparently) connected via the webserver to my PC.
So far, so good!... then I reformatted my pc. This time I installed
Windows XP and SQL Server 2000 as well. Now when the customer wants to have
access to the database... the application just won't pass from the login
webpage. Then I suspected that this was due because of SQL Server 2000.
And even though I'm not very proficient with SQL Server I ended up believing
this is the main reason for not having access to the database as before. I
tested what I state before by accessing from another pc (my laptop which
also has Windows XP and SQL Server 2000). This time I have access to the
database.
In brief, the problem is... the Production Server has Windows 2000 Advanced
Server & SQL Server 7.0 installed on it and my PC has Windows XP and SQL
Server 2000 installed.
QUESTION:
Instead of just uninstalling SQL Server 2000 from my PC, is there a way to
access the databases that reside in my PC via the webserver (production
server) from another computer? Do I need to configure something at the
webserver or at my PC?
Thanks one more time for your time and patience
Félix
"Félix Meléndez" <fmelende@.ibw.com.ni> escribió en el mensaje
news:uRJCsVPcFHA.3400@.tk2msftngp13.phx.gbl...
> Adam,
> Thanks also a lot for your time and patience.
> On the other hand, before turning to the newsgroups, I indeed uninstalled
> SQL Server 2000 and then tried installing back again SQL Server 7.0. But
> I do not know why I began getting an error about "Enterprise Manager.msc"
> not being configured correctly. As soon as I clicked on the OK, button,
> the whole installation rolled back.
> Mark Allison also states that I should read the article about
> "Uninstalling SQL Server 2000...".
> I'll try to do it again... this time following both of your advices.
> Thanks again for your support.
> Félix
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
> mensaje news:udgUnwOcFHA.3488@.tk2msftngp13.phx.gbl...
>> No, absolutely not. What it means is that you might have to un-install
>> SQL
>> Server 2000, then install SQL Server 7.0, then install SQL Server 7.0
>> SP4,
>> then re-install SQL Server 2000 and update to SP4. You can detach and
>> back
>> up all of your databases first, then re-attach them when you're back up
>> and
>> running.
>> Another option might be to use a Virtual PC for the SQL Server 7.0
>> installation. Have you considered that?
>> --
>> Adam Machanic
>> SQL Server MVP
>> http://www.datamanipulation.net
>> --
>>
>> "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>> news:%239r0roOcFHA.2980@.TK2MSFTNGP10.phx.gbl...
>> Adam,
>> In other words, does this mean that I must reformat my PC?
>> Thanks for your time,
>> Felix
>> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
>> mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
>> >I believe that SQL Server 7.0 would have to be installed first, and
>> >then
>> >SQL
>> > Server 2000 could be installed as a separate instance -- SQL Server
>> > 7.0
>> is
>> > not instance-aware, so I doubt it can be installed second.
>> >
>> > --
>> > Adam Machanic
>> > SQL Server MVP
>> > http://www.datamanipulation.net
>> > --
>> >
>> >
>> > "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>> > news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
>> >> Hi there! I have a PC with Windows XP Pro installed. I have it also
>> >> with
>> >> SQL Server 2000. I'd like to install back SQL Server 7, but I keep
>> > getting
>> >> an error that Enterprise Manager.msc can't be installed.
>> >>
>> >> Could someone shed some light on this? What are the steps I must take
>> in
>> >> order to install SQL 7 (previous version).
>> >>
>> >> Thanks for your time,
>> >> Felix
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>|||I just followed Mark's advice to read (How to manually remove SQL Server
2000 default, named, or virtual instance
http://support.microsoft.com/?id=290991) and "do as the article says". I've
attached a print screen of the error. I don't know why it did not work for
me, since all the steps were pretty straight forward. Is there another way
for doing this (uninstalling SQL2000 and installing back SQL 7)?
Thanks again for all your support.
Félix
"Félix Meléndez" <fmelende@.ibw.com.ni> escribió en el mensaje
news:uRJCsVPcFHA.3400@.tk2msftngp13.phx.gbl...
> Adam,
> Thanks also a lot for your time and patience.
> On the other hand, before turning to the newsgroups, I indeed uninstalled
> SQL Server 2000 and then tried installing back again SQL Server 7.0. But
> I
> do not know why I began getting an error about "Enterprise Manager.msc"
> not
> being configured correctly. As soon as I clicked on the OK, button, the
> whole installation rolled back.
> Mark Allison also states that I should read the article about
> "Uninstalling
> SQL Server 2000...".
> I'll try to do it again... this time following both of your advices.
> Thanks again for your support.
> Félix
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
> mensaje news:udgUnwOcFHA.3488@.tk2msftngp13.phx.gbl...
>> No, absolutely not. What it means is that you might have to un-install
>> SQL
>> Server 2000, then install SQL Server 7.0, then install SQL Server 7.0
>> SP4,
>> then re-install SQL Server 2000 and update to SP4. You can detach and
>> back
>> up all of your databases first, then re-attach them when you're back up
>> and
>> running.
>> Another option might be to use a Virtual PC for the SQL Server 7.0
>> installation. Have you considered that?
>> --
>> Adam Machanic
>> SQL Server MVP
>> http://www.datamanipulation.net
>> --
>>
>> "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>> news:%239r0roOcFHA.2980@.TK2MSFTNGP10.phx.gbl...
>> Adam,
>> In other words, does this mean that I must reformat my PC?
>> Thanks for your time,
>> Felix
>> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> escribió en el
>> mensaje news:OMJxJcGcFHA.3204@.TK2MSFTNGP12.phx.gbl...
>> >I believe that SQL Server 7.0 would have to be installed first, and
>> >then
>> >SQL
>> > Server 2000 could be installed as a separate instance -- SQL Server
>> > 7.0
>> is
>> > not instance-aware, so I doubt it can be installed second.
>> >
>> > --
>> > Adam Machanic
>> > SQL Server MVP
>> > http://www.datamanipulation.net
>> > --
>> >
>> >
>> > "Félix Meléndez" <fmelende@.ibw.com.ni> wrote in message
>> > news:%23y8VwVGcFHA.1152@.tk2msftngp13.phx.gbl...
>> >> Hi there! I have a PC with Windows XP Pro installed. I have it also
>> >> with
>> >> SQL Server 2000. I'd like to install back SQL Server 7, but I keep
>> > getting
>> >> an error that Enterprise Manager.msc can't be installed.
>> >>
>> >> Could someone shed some light on this? What are the steps I must take
>> in
>> >> order to install SQL 7 (previous version).
>> >>
>> >> Thanks for your time,
>> >> Felix
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
begin 666 SQL7.Install.Error.rar
M4F%R(1H'`,^0<P``#0````````!RYG3 D#L`*B,``#8`) `"T#PQ%)%EU#(=M,Q8`( ```%-13#<N26YS=&%L;"Y%<G)O<BYB;7 `\%7@.&AG>$1%54(E8$B(U
M98@.(@.=+,JV=1+$!,5CU'$**G>JCTPJ*C@.!,"]Z@.@.6)@.5,*6 HH(68$' 9K"Q
M%!3$B)^@..%F6[LS67D,J8FPU[Y\K[6O>BGON[YM.=W>\&MZWSG+,.I\CS7D5
M$Q,1$S-;U7Y,U-3K?.>:\Y_*_+_PD3$3$3,8)G[Y,54;Y/*K=:U55O55JIF?
MGY77NLY.$R<S+_YU.H<R9SG".!PIP&3I&2GA,?R_[K>#X 8);KV?&</@.^ &!
MFJ/S+4U/73X@.`P$S:^'X?)/@.!ACT_/@."=P?GP!.Y)\ )V? "=GP`G9\`)V?
M"=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\
M`)V?`"=GP G9\ )V? "?GP!.X/SX`G<'Y\ 3L^ $[/@.!.SX`3L^ $[/@.!.SX
M`3L^`$[/@.!.SX 3L^ $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/
M@.!.SX 3L^ $[/@.#!Z?GP!.X/SX G4^ )V? "=GP`G9\`)V? "=GP`G9\`)V?
M`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9
M\ )V? "=GP!.X/SX`G<'Y\ 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.S
MX 3L^ $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[
M/@.!/SX G<'Y\`3N#\^ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V
M? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP!@.
M]/SX`G<'Y\ 3J? $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.
MSX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.SX G<'Y\
M`3N#\^ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ )
MV? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP`GY\ 3N#\^`)W!
M^? $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.SX 3L^ $[/@.!
M.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.SX P>GY\`3N#\^ )U/@."
M=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`
M)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ 3N#\^`)W!^? $[/@.!.SX`
M3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.
M!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.SX 3\^ )W!^?`$[@._/@."=GP`G9\`)V?
M"=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\
M`)V?`"=GP G9\ )V? "=GP`G9\ 8/3\^`)W!^? $ZGP!.SX`3L^ $[/@.!.SX
M`3L^`$[/@.!.SX 3L^ $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/
M@.!.SX 3L^ $[/@.!.SX 3L^ )W!^?`$[@._/@."=GP`G9\`)V? "=GP`G9\`)V?
M`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9
M\ )V? "=GP`G9\ )^? $[@._/@."=P?GP!.SX`3L^ $[/@.!.SX`3L^`$[/F'T^
MMYGQA<'#XNXOIV?,.SU?RVS/C"V,S^9].SY=QJ_E5B^,+2Q?GT[/D[/DZGT[
M/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[
M/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[/D[
M/D[/D[/D_/D[/D[/IW!^?)V?)V?3L^)V?)V?3L^)V?)V?3L^)V?)V?3L^)V?
M)V?3L^)V?)V?3L^)V?)V?3MQ\F;:WHHN@.T[F?,,9T^'Y/IV?*[]3V#GI>:RU
M$.CX`7+CG/Z?$:?#\GT[/E>>7-JHS<O3[L NGQ&9^?3L^6$:)V ?%\8NSZ=G
MRQ/>8 7'G;J=GV+N2?)V?+ <:ZOKEV67#X?O%_3XF"FGP_)].SY8;FBG.=@.+
MUJYI]@.!=/B8+Z?#\GT[/EC.J?3S79_:UZ?8`73XF+L^3L^5R:@.\S'5N\_N\/
MH^?YK< +I\/S3XD[PZ?3L^5_XZ,VCA]KEF\G[',#7K<)/$:6UWW_5H^RZSYI
M\/S3XD[/E@.^\P MHQWY_[1XJQZG-C_-I62NS3X?F9].SY85C/U='MY= EF_I
MLV<7=BDWA^\3[SUV*YM-%V,[GW+LR?8P)H+/;&!L_&FS6'-<TV,7,XJ:Z:T2
M"=:SFXJS9Q#G*V:/'.S1MKJ=T=E:#1=<GT2%=Z+;6;;SEE_[`2T^'Y/IV?+
M<FOP`N3A]&EN?: 7;@.[6N$[;$-MMP37:0D:Z=VE3;H7V/KL5;<H=UMS/:/'&
MTJFXH)UI^_Y#H\<VWK4^^\$9^^?..O?<S/IZW=/A^:?$G9\KLU1U>NS\;)S7
M`"Z/*T;U@.NLX#YW$*/[-Q;2UMI5MB_6?$,Z.)TT%R[<+GT>./L0'YF]6W+./
M(T>/-Q7S[,6;K-BV,;CQ?GT[/E=/,CK+TZNO^-MS_-Y@.+?_/%S3="G=9N)CH
MM&MEH(9_C[=BGVZG]F2;U:/S:65FW-N%S[ECC:5C;H)VFN^\FM$5LF@.7K;<L
MZ#8SM*3/QYMU%V,+ZY8T>]3::_\Y'GV/EI\/R?3L^5W[#9]?ZNO[V3'5Z782
M^KI#;6:/XU3-2!M'+/:SYS@.2S.!W6W4O7!WF<4UU'V,UKO75,W+#_;GUG*E[
MXTO;H)V98T1E;E@.,XLYQ6VF"=RLK./]LR?8\6Q4T>:S\>?8^6GP_)].SY79J
MCOG-=GOVL\OJYD)5M_E^;X?+_.<!^:X-5H.<O=I;F<G=B(8UW%L3]N#N]F9[
M7)-N?O:7ZVF:WB'0;1M'@.G9F<VY6V:N^<XMROUK3]R\IW>NL:IFXN6C.1ILS
M3:6Q]D1:?#\GT[/E=F\'=;#XOO:S9\GF4FUES:#\^P<(7G'UO!)F]S9VD0MS
M8EG!.GUL@.G'H-FJ+CVNW-G3X?C3XD[/E=O,CU^:X`7>(=;G[W5'^9=H+?V/S
M;AM-B&W(;Z]OUV:[BOK[[S6TI_L<+,_/IV?*Z==@.!=0_'P]KT*QORK)O=.Z.
MTWNP`^CB%M^I;2V,Y!.-TY-9+-UFB*V]8_-FCG>&?9*69^?3L^5V:W "ZH&-
MET?F7-WNGQ&&`S\^G9\KOW@._:G8?K?<S@._S%_3XB=GT[/E?VL\B/:S2!_+FX
M.9^?)V?3L^5_5;]9<'Y\G9].SY.X/SY.SZ=GR0T]T?F+Y.SZ=GR3N%B_/D[/
MIV?+$.'T:4_B^3\^G9\L+QYT_B^P=GY].SY7]O,`+FYV+^9]@.[/SZ=GRP'ZO
M[0-9N7JX`7,_I\2=X=/IV?*_\9S?QW6AMS3XC#$-/A^3Z=GRP>?$[/IV?)V?
M$[/IV?)V?$[/IV?)V?$[/IV?)V?$[/IV?)V?$[/IV?)V?$[/IV?)V?$_/IV?
M)V?)W!^?3L^3L^3N2?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?
M)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?)V?+?S/C"U9_%].SY=W/C
M"VY^?3L^`$[/@.!.SX 3L^ $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^
M`$[/@.!.SX 3L^ $[/@."=P?GP!.X/SX G9\ )V? "=GP`G9\`)V? "=GP`G9\
M`)V?`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=G
MP G9\ )V? "?GP!.X/SX`G4^`)V?`"=GP G9\ )V? "=GP`G9\ )V? "=GP`
MG9\`)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V?
M"=GP!@.]/SX G<'Y\`3N2? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?
M`"=GP G9\ )V? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP GY
M\ 3N#\^ )W!^? $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.S
MX 3L^ $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX P>GY\`
M3N#\^ )U/@."=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V
M? "=GP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ 3N#\^ )W!^
M? $[/@.!.SX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3L^ $[/@.!.
MSX 3L^ $[/@.!.SX`3L^ $[/@.!.SX`3L^`$[/@.!.SX 3\^ )W!^? $[@._/@."=MGP`G9\ )V? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ )V? "=GP`G9\ )
MV? "=GP`G9\`)V? "=GP`G9\`)V?`"=GP G9\ 8/3\^ )W!^? $ZGP!.SX 3
ML^ $[/@.!.SX`3L^ $[/@.!7=B^&%Q</.XOA=AJF9GPPMG%_,^%VN[T?F+X86G
MB_/A.SXG<D^"=GQ.SX)V?$[/@.G9\3L^"=GQ.SX)V?$[/@.G9\3L^"=GQ.SX)V
M?$[/@.G9\3L^$[@._/B=GPG<'Y_#Z&3-CVZQ=Q?G9\)V?7NZWCC$_B_.SX3L^M
MSF?^;A]FQ#%_,_.SX3L^N%JGXX5B_/SL^$[/IW!^?G9\)V?3L^G9\)V?3L^G
M9\)V?3L^G9\)V?7U]AO\<S>K%W,_.SX)^?L*V8?5L3,7<S\[/@.G9^P_4;._G
M_U&#%W,_.SX3L^L#^L YB?Q?G9\)V?3N#\_.SX3L^K.T]T?F+\[/@.G9^QS3W
MR_,7YV?!.S^9K3W<_,7YV?!.S^+5XT_/SL^$[/IW!^?G9\)V?3L^G9\)V?3L
M^G9\)V?3L^G9\)V?6NQ.?GYV?"=GUOV.3L_.SX3L^$[/A.SX3L^$[/A.SX3L
M^$[/A.SX3L^$[/A.SX3L^$[/A.SX3L^$[/A.SX3L^$[/A.SX3L^$[/C!V?GP
MG9\3N2?!.SXG9\$[/B=GP3L^)V?!.SXG9\$[/B=GP3L^)V?!.SXG9\$[/B=G
MP3L^)V?"=P?GQ.SX3N#\^)V?"=XR?"=GPG9\)V?"=GPG9\)V?"=GPG9\)V?"
M=GPG9\)V?"=GPG9\)V?"=GPG9\)V?"=GPG9\)V?"=GPG9\)V?"=GPK_]'_GZ
M'BO!<1Q7$>#\KX3PMEX7#/>&>%YJDV)^,^$\-Y/P?A?+?V>+]5Z[V6ZT-_-/
MB&"6GP_)\*Q>)\7XWM?X/X?9^K<+V?J_6+8_9PU=GP]'"]EZQ^!VCJO5NX]$
MZ!VS@.^E=Z[#V#U/%^PW4[/B=GPK<_ ]'\#)_C[KG'D_7<!Q/L,GE*G$X?_J\
M7D_8_3'LLG%8THYD_6+&-=1/Y;CN<>:][UG]WO?<NA<^[7]WP?$^#\+HD":?
M$,#]/A^3X7G_K^LY#)Y?C<GF?=9/.>^R>;]_;/G>/R>@.Y+)Q?T,GKN8R>F^1
MD\]\'_A/P,/W[[F4GG_J%>E^-D]EE[%^9V'ANC\%XOOG?=!@.33XA@.EI\/R?"
M\_A/3\CD\[[[4'VN`]3\C)ZSYG >L^7P'K<<]4SB_FY/:9<GN<O3.U]]_3[1
M_!UK^KS>3VOT]Z[Y^3UOS/_JMNOE_4X^9_^W_"=1FO3?&R>VR_?_O^!_>_Z<
MZ\]YCS.@.P)F?&"6GP_)\+S^Q^NY+)Y_X.3TOPN<_\1YS[G+P''8ZO]QR<IEZ
M1^)U[H^3)VK[;H^7S7H^P>,\_DY+_=/;ZQ6XWF?7GWP,O._IC_^!^7J377^O
M]D[WUK\+07^T^(8*Z?#\GPO/\5[+W>3T7)9/3<MSOVG,<_Y#+DXZI[9QF'^]
MQA3X&7G.3)T-VCI7"\-]QTOLO:>\Y/B;M8U53VV.7VWNLO!_'R\ZX[F,GL<*
M>L^3V_I/1>)\'X;,[/\WOUOKNGT>8OX?)]>OHCW=/A^8OA>?1TKUG+Y/2\GD
M];\CH/(9>=>]RY.-RV7'6?NL*<KEX+I/":G4GZ34ZPZ9V7NN3X^-/;[N=XW'
M\Z)RV7[GXOTQZ_Y^3C\O6>Y_Q]\ZMU+3W<_,7\,]/A^3^%Q?7*^[B_B^%87=MO9_ R>DY')ZOX?/?=_2X+E<*>YW8]_C'N,<^7R\Z\KZW@.LF3G=3[OI/3\G&\
MQDX_=JWN'&Y>!]YEZ=S&7GOO]WV OV/R^U=4ZIX_OO...5LYN@.VWZ\__.9>;V
M'TER\_Q;Q#LOV2:MC1\=>S*V?J/GXJSCZV9E;&%=Q1MLT6MC5YF]6@.L]G)K.
M-39KTSETFTV,[3>YKIW::/H-8T>\WL:G]C2\GV2<U>\2:/9+L4^Y85S[GV*'
M>Z\K/_@.+L6QK9W.%I\/R?"L*CG/J^6R>JY3G'L_F]$^'E^WY#=CW]'NL*>[>
M^?#?$?+?"<J]Y]6:W> IZ3\G+T[Z.%.,^CD^#EZCW_QO?/ONF^K]A[3=9N)F
MW]=UHT0/_WK7-7U^L:'.%ONV-\;"MQ#\SBSH-8WHNFWHL-;2Y]^7*+L4.Y;$
MT2G>;3F.;B?6Q+>NPWL3]_<<:U/O^O*V)F@.\5L:?#\T^(*Q>Z^UX_)ZSE<G%
M_$Y][_Z70OBY> ][NQ[_&/>84U#^/J<CEZ%X[TF3DK/WF[FM1/[C+SK4'[?4
MH^XY'&G'<QJ(?VNH]0XK^?P6ZS?)M/5(T'K^]Z%S9LP$YO4.W5UWW!>MX6Y8
M#1P?F<6<XDWK$5[<V=IAOZY#\T%FMRK'V4<U>;E[3=]W$UL?,WESS1RQ?GPK
M%HZ-['X63UO*Y/:_*X+XF7[?E-V/?T>^PI[]R67@.?;_._+Z#P?,G\KNTFK.^
M\R])^;EX/Y]3C/H:B?A>'\)WWA>I^J]?[/4?K?J6W=9WKN_4;B7-=1]$`*[Q
MFOK8%6W*"]9R:V(+K5EO0#\SEA[019[0;7^M6-$NDS]9MCZ[& WKO_9^=O5L
MRQG[#FB<AFXH#;K%-ICG7+&W/WL8M[=7NW]!YR-N9K>W1^:J'<18NSX5CT=Y
M]M\')Q?)Y/8?#YWQ_,<%\C+P''[L?S1J&?3W/O[O5_GY.=\XXOX>3XV[0ZB?
MWN7G?)Y>$R\SV 74/R<;\KM/4^I>4[_X#4=_?P6Y>N;WTZ_K1VF<5MRLYLNL
MDT<'MG[+NB,K/MC7<6Q<NY85T%4V:Z;?2VK?<?FXJQ?%G$.^E?N/09SFKWKL
MEV/KOO'&^/XGMFJ/:]<GW*6GP_)\*R*.?^T^%D]=RF3C?D]!^+EYYR^7)\'"
MG(.1?2R\'W?P/;,F3G7F/8Y/G[M#Q]ET;YN7[G4XO;_/R<MEZIW_^GA^H<)O
MWU_SKNK>V.7.MF!%9S+S6S+FM0ZX_1'ZV-'SBMGPE.?CS:0ORV-IA?>'[=.Y
MQN;BA7.5DT2LVS(<Y=)KJ=VZ+>S,WH\/]RW_-BU-'6=:AUQ^CQ>UU'SBML8M
M[3>5G'/G^4[LWKG&IG+Y]I0Z#:&XH&S5VFO_1"T^'Y/A67WCC./R<7R.3V7+
M<\Y+F.?_)W8^YR7,Z/T^H5TOKG9.\9,G1O"^6R?0S4Y-R&7G/*?[I_N_/.5^
MED]W\[4XOV^G\)Y#^3OVH[N_LM=U;F^[-[[K&_*C[,"KWQ;&XE-IM7WTJ7N)
M_/K [^B01]:8#;G+]K...7KN6S.<6]<-_6:\YOO;:T^'YI\05ET<%[/E,GL>3
MX#W/RN@._+R_;<ONQ]7R*G*Y>$Z/T_T'Z_:^L=A_:U-H!^6PIR.7H'^N;+)[[
MZ&3XV7JO?_$</U#[SU'K.+W6'49.:RONZT_FQH^QHN^E;-Q*9S-!]\6QN6+>
M_4/'UO%G.;>./M;YJ^;H?FMA7ZZEB_/A7QV_CO@.Y/8\CDXWXG/_BY>?_,W>?
M^?1QIZ'V?WF3)X;K?8>O\+USF<_SXF%.6RXQT/Y?,Z0FX_Y_9^L=8\=WKO6Z
MNNWNZK>_6G=U]K6=%W@.;^!^?:K;M]F/-7I\69V?"P2C@.>,Y;)QG*\YY+YW0_
M]LO _'J?4'X#R7G.J9,G[G3/P>P=/ZUSCU_(9/FY>?8TZ=C3)RCY&7J/A_'=M]Z5TCT^Z]=NL.]GQAA$_/A6CPWM^0R>UY+)[OY'0/F9>?_2PRY]U_];JV3)U
MWGG2_S.<=*Z'Q'D]1#TO&G1?GXTY+_;)\G+VGJ_5O']U_AW6AMS%\,79\*V*
M.>^WY;)[CE>!Y7Z'0_J"<XJ<ZY[T'@.\F3\?)T7\G_X_>?I=NX'-3A,::FD!_
MFY?O?%>3[WP?2O2^G]7NL7<5OL_T0MI[HMC%_,[/A.VGM'N^2R>WY/)\#X_0
M*GW%3@.,F3HCKF3I'Y=3J7XW8>BNC81\.I\K+^K^1^3X[AN&W6+N+K%].SX6%
M49/>\MA3E^!^/EU.P"\ZR9/MZG5\G/>%QIU7KW[&IL_Q\K>,OW?E...=YZ'
MT'FWS_S8;'K<UV0TV98SE'UR?8NO-N9Q4V9^\XSFW+F@.LK/V'MB[^]'%H&R]
MFTVACKV:YUM-P^B5:T2NN?M#7<6GQ,/IZ?#\GPK7[3[SD,GNN3R<G_KJ=@.%X
M+RG%-27/,U.F_!Y#H>:/C\QD_VR]D^I1XGM?:]1J9NRUP8S:1#&CH=BGSXT[
MO[@.;>%OC3^^C*T=GM':FS(=NJ+OI1=FI_.+.^[9T^)AUVGP_)\*U_4^R]MP'
M'\MD^!RW`_+YGL O`_-^ESCS_J.>_3'3<U. ^=FIC3@._\/.=XZ-T+T/^GHZ\
MMQ">:]=NHNN3ZYGLW%T%_+K\_47?&#,7=/BG9\)VK^I[_D\GO^4R<K\C4[ +
M]O4R/NMWK_G_7"GTLO8_S?SO$]J[3NL.WS<78:&R]NMEHXA-^4#;PMRT_M>B
MI-FK3H[*UM%URI>KZ]C\UT$[3&VQ6<SNGQ3L^$[?TR<ARV3D>6YS_K\_@.MW@.
M!>H84R?.^EJ8`[TCT'I.Z= Y[Z/T/I-UFL';E;>L<MO[@.;06F?&/]!96?0[E
M5-IAO5,WKK1L6;T>BZ"Z]Q4O0;U-/B8=II\/R?"MWLG'\EDH^)\GI%3A:G3*
M/E_0=CZ[UW^CLW9M56Q[7'U;1Y.UK13O8H=F6=N9K:85VZ!MIBK.1:T?BS[E
MVY#N54S;&@.C.='9O9J+]-Z%5K>BHNMI_..O3XF'>Z?#\GPK=]#[3C<G*<ODY
M;X71_H_2_<RZOQ@.?Z+ZKU?=>"Z#Z#SOG[P-Z*=T&EZ(W-$6-'H^TS7V@."CN]
M%1=B.9^O$&:?$P[W3X?D^%;M'7^1Y3)R_+\#]#Z/4^9\`%H[!^CV+R7=>[:L
M[=QF?XS!U/SL^"L#U-3)\KY63YOSM4?YTSUOK>*_D_FP[Z^+'^-Q;Z]@.F^&C
M76GP[UB_F=GP5@.T>6X[W/0.8YCG=3K/R?E>HW7K\>OQ?&+L^"M6CT7M>.XCW
MW'XNSXQ=GPD9\)V?"=GPG9\)V?"=GPG9\)V?"=GPG9\)V?"=GPG9\)V?"=GP
MG9\)V?"=GPG9\)V?"=GQ.X/SX3L^)K1%S%\&'"QU]LX3GM'[O3ON,/S[WGW;
M<(Z>Y_VYU!T#M[J+_HX;[YT'ANI=![AAEP7<.IX1T+]YU1T/N+JKHG<NK83T
M7N75^B]SPRZ-W/A>C=T='[IUA^_]_TC"?X/^W2</S\#I7\.$]9^Y[KA'X+[K
MNS\)P;N_X;I;O'XC_KWC\5]WWE^,Z9_$ZT^\[T_'=-[U^1TWA\,N$__\.$[W
M9=.[W^2[Y^3][WS\IWW\OI^$_Q]<ZAA^?]^H_R83_X^^[]A'YCJ3^7\UU-_-
M^<ZIAEUWJO?$_/=6\ _\NK_SNO.%>!Z^ZQX'L'6/!89'^"["XCL/_;B.Q/
M!]B_`\'^@.$^AUGPGZ.&?8_P?"X3^E^%X9^G^'A']#]3\1X?LC\5XC]7\;#\
M_6ZU_3A/Z_X_]6$?L/R']?976W]G9GY+Q/[+\KQ/9\,O%=G_+\5VAXOM'7/%
M]IPG_OXSM6&?[7_CQN$_M_F81XY_Z_->/?^_SGD/W'7<,NU_G^1PGMG_GR3]
MWKV$<3VUU]Y/MSL#RG;W8<,N&[#Q7#=BXKN#RO</T/*_O83^C_;W%V/RW<L,
M^Y_I?W83W3]/"/[W[_ZCR[^#LF&7\/ZOF,)[K^M_@.[M^OA'^+N_[#S/>'97F
MN\NS89?Q=F\W_%^R[U^SYSO79_.</A/:/.][=I\]WQVK_+ON&?\?[6$>'R?
MMO\W?O_6&?_OT'\K^;]S_3">_]K]"\!VS"/1/Y_W7H_ NVX9>"[;Z3P7;G$=MN]+Q';W@.$X;TWA,)[AZ?PK][U'AG<?4?T=Q]3A'A^Y/5/$=SPS[IZO^G"?W
M_6?U89_U_P;K"?[/X<(]:\3W5Q;Q7=L,O%]V]=XON[QG=_7^,[P\;WCV'C>\
MO'81_%[%X]WKV7D,)X?V7D>']GAEWOV?DN]^T=\]IQ/?/:\3WWVOD$_C]MY
M1_)QG%._<9Y7OW&X1_;_*XYY;^;"?;_W=_>X_O\!AEY?P'N?+_SO,81X'W3_
M!X+W;_%Q'N_,\1[S#+P?O/->#]Z\)[WS?A/?>;\*\YA'AO?^=PG^CX'GGA_@.
M?Y>'X_#+Q''^?\1\'"/\_Z7(/0?U83R/^G];DO0_V89>BPCQ/)O1O%<H](\6
MY7TKQG*^F\9RV&7C>6]/XWEWCN7]1A'C_A/4O(?#]5A/D?A^K\C\3#+R7Q/6
M>2^*XGXNZXGXV$>M\GA/Q^+\IA\6-?':R7C\.5Y!Y%Y+#C\3ARO)O*.*>5PX
M_]N'*\L_N?WO+X<?S&'*_P?XO,X<?S6'*\V\X\Z\]AQ_\L.5Y]_F] _TPX_H
M<.5Z)Z-Z3#C^EPO2?!@.Z8/X.L'PP^UUNYL_@.[@._@.ZPP#K=WN];GQ?PX?_W_
MO-/X6EJW-3["Z-P?[O!9_!W!_!UA@.>Y'TW*IO6Y\S^X\_S_G "XOC#H-P^+
M,S^#N#^#K# ]Q>_IN53>MSYMS4/MC5"UT:IE.MSRU1C-HUJI3K4-76I*<9JY
MJVBBV-58IR\UE1JF4ZI].N6=CG^8UQUT9IIIIIIUU'HIIQFG-6UY>:RIUJ&F
MFG--&M6*NM24XS3EYK*UZV:IS33K9VUYM&,8UUR>G><5.N5JN:L^8.L'V#N%
MN9-A*]N2]E8NJ9K<_S'7J\6,ZI]HU4.\'^8SFG7#\IQV,=S-.,X[F,XSC7&<
M==-KQW\9QUX[>,X[%-KIIS3F]6-=5#C'_)F;/5/S:,TYMS&:MHWF`%QW*N:<
M=>JDJZO%3JGVNF=879L>@.+L?XNAAB&3<@._+;M_0>BQ>9EUDI_#ZN6_^[+F
MNC\G<'UQ-;[S.N][YF?P=P?P=9G;X=!Z+%Q=4*M=9ES?NZ#55,>LQ]MSLNPE
MC]W'8N%>V^+>-:UXZYW!^&S^4'\7\'<'\'3#^VW=%BX6M#!<O5E;FL\OR^76
MOW:\:V_5N%3<ZF\FT7"INLRYM6,XS3.X/R6R_U%\XOX.X/X.F'SY_HL6_O)=MM^]Y]JF;A\OS--M[#1^7MU)9JX[>->\?B_]=4S:<_S=[/YES:JN.C=^7^:!Y
M?FLT?F\EX#\_JV\/^KL_FM5-9H_-Y+-.M0YM_:_+\WDOJ[/YFUYN7=33CL6C
M'15O;.M/L_S!T&'<ZLL:[Q#]9=S\QXN::N:OV9_%^8\NZ^K;_,KS:Q^<S,7-
MS;%,_/Z>Z_R?P=P?P=+Q=26@.;GYFL*]M@.]ZKQLW63[3W9_&#I/X.YNKQZ#[
M_B_-X(ET]_0_,?J[B'YB_/L79_!TP?PM:Z#%W3W]/\S/C!W!_!TT[^7\GPP[
M?1Y3^#N#^#K#!MQ>_IEW(IO6Y\SX:>_N?F#J?8.SL^#!TP?P=:>_R/S3XA.S
KX3N/YI](,+6^KXP^GP8=-I]E+&GQ#"Y=/O>NSX8=?J=%C_\0Q#U[`$ '````
`
end

Going back to SQL Server 7...

Sunday, February 26, 2012

glyphs

When I export reports in pdf, I have glyphs in some textbox, I use Arial
normal 8, and I checked, the font is installed on the server and the client.
I only have the problem in acrobat 5. Any solution?Adobe 5.00 and 5.05 do not render symbols correctly when the Arial font is
used.
This table outlines some testing I did to determine how various Acrobat
versions behave when attempting to render the euro symbol. The results
should apply to symbols in general.
Version Font Handle Euro Notes
5.00 Arial No The text is also trashed when
the euro symbol is in the string, The text renders
5.05 correctly when the euro
symbol is removed.
5.10 Arial Yes The text and euro symbol render
correctly.
6.00
5.00 Tahoma Yes When this font is used the string and
euro symbol
5.50 rendered correctly.
5.10
6.00
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"raph" <raph@.discussions.microsoft.com> wrote in message
news:04488328-BAC7-4DCE-85D4-83A88D11A8E9@.microsoft.com...
> When I export reports in pdf, I have glyphs in some textbox, I use Arial
> normal 8, and I checked, the font is installed on the server and the
> client.
> I only have the problem in acrobat 5. Any solution?|||Thanks for your answer, but I am not using euro symbol, here is the text
"Anal. production, Syst. DÃ©cisionnels.â' Consultant". I think the problem is
"-".
Do you thing that changing font will resolve the problem?
"Bruce Johnson [MSFT]" wrote:
> Adobe 5.00 and 5.05 do not render symbols correctly when the Arial font is
> used.
> This table outlines some testing I did to determine how various Acrobat
> versions behave when attempting to render the euro symbol. The results
> should apply to symbols in general.
> Version Font Handle Euro Notes
> 5.00 Arial No The text is also trashed when
> the euro symbol is in the string, The text renders
> 5.05 correctly when the euro
> symbol is removed.
> 5.10 Arial Yes The text and euro symbol render
> correctly.
> 6.00
> 5.00 Tahoma Yes When this font is used the string and
> euro symbol
> 5.50 rendered correctly.
> 5.10
> 6.00
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "raph" <raph@.discussions.microsoft.com> wrote in message
> news:04488328-BAC7-4DCE-85D4-83A88D11A8E9@.microsoft.com...
> > When I export reports in pdf, I have glyphs in some textbox, I use Arial
> > normal 8, and I checked, the font is installed on the server and the
> > client.
> > I only have the problem in acrobat 5. Any solution?
>
>|||Everything is perfect with the font Microsoft Sans Sherif!!
"raph" wrote:
> When I export reports in pdf, I have glyphs in some textbox, I use Arial
> normal 8, and I checked, the font is installed on the server and the client.
> I only have the problem in acrobat 5. Any solution?

Sunday, February 19, 2012

GK - Blocking the unauthorized use of the SQL Management Console ( or third party tool

Hi to all,
Whenever SQL server is installed onto a server it can be accessed by the SQL
MC and easily registered for use. Whenever someone not authorized installs
the SQL MC or a third party tool with the same capabilities all database con
tent can be altered !! THIS
IS A VERY SERIOUS THREAD !
Is there a way to prevent this?
GKramer
The NetherlandsCan you please elaborate on your concerns? Only users who have been granted
access to SQL Server can connect and access database objects. When SQL
Server is initially installed, only members of the local Administrators
group can connect. Once you grant an account access to SQL Server, they can
use any tool but are limited by the SQL Server permissions you have granted.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gkramer" <anonymous@.discussions.microsoft.com> wrote in message
news:2BDA7DD5-3FDE-45CC-BD95-BDCD8AD01BDE@.microsoft.com...
> Hi to all,
> Whenever SQL server is installed onto a server it can be accessed by the
SQL MC and easily registered for use. Whenever someone not authorized
installs the SQL MC or a third party tool with the same capabilities all
database content can be altered !! THIS IS A VERY SERIOUS THREAD !
> Is there a way to prevent this?
> GKramer
> The Netherlands
>

Thursday, March 29, 2012

Granting consultant access to database

Friday, March 23, 2012

Grant Database Access

Reporting Services Server Defaults

Grant Database Access

Reporting Services Server Defaults

Monday, March 19, 2012

got a problem when try to connect to a sqlexpress database with c# desktop application,t hx a lo

Wednesday, March 7, 2012

Going From SQL Enterprise to SQL Standard

Going From SQL Enterprise to SQL Standard

Going from Express to SQL 2005 Standard

Going back to SQL Server 7...

Going back to SQL Server 7...

Going back to SQL Server 7...

Sunday, February 26, 2012

glyphs

Sunday, February 19, 2012

GK - Blocking the unauthorized use of the SQL Management Console ( or third party tool

filtering with set

Blog Archive

About Me