\Backup directories - remove safely?

I've successfully applied SP4 to an MSDE 2000 installation on a
Windows 2000 Professional system. Now I've notived several \Backup
subdirectories in the "Microsoft SLQ Server" directory. Since I don't
want to go back to any previous version, these subdirectories appear
to be no longer required. May I safely remove them?
Heinz Wehner
(Karlsruhe, Germany)
Hi,
No problems. You can delete that directory.
Thanks
Hari
SQL Server MVP
"Heinz Wehner" <hwehner@.hotmail.com> wrote in message
news:c215e1ppe9k9vqim24ckphf0eukkgr6n5a@.4ax.com...
> I've successfully applied SP4 to an MSDE 2000 installation on a
> Windows 2000 Professional system. Now I've notived several \Backup
> subdirectories in the "Microsoft SLQ Server" directory. Since I don't
> want to go back to any previous version, these subdirectories appear
> to be no longer required. May I safely remove them?
> Heinz Wehner
> (Karlsruhe, Germany)
|||Thanks Hari.

> On Sun, 24 Jul 2005 19:32:03 +0530,
> Hari Prasad <hari_prasad_k@.hotmail.com> wrote:
> Hi,
> No problems. You can delete that directory.
> Thanks
> Hari
> SQL Server MVP
>
> Heinz Wehner <hwehner@.hotmail.com>
> wrote in message news:c215e1ppe9k9vqim24ckphf0eukkgr6n5a@.4ax.com...
> I've successfully applied SP4 to an MSDE 2000 installation on a
> Windows 2000 Professional system. Now I've notived several \Backup
> subdirectories in the "Microsoft SLQ Server" directory. Since I don't
> want to go back to any previous version, these subdirectories appear
> to be no longer required. May I safely remove them?
> Heinz Wehner
> (Karlsruhe, Germany)
sql

[WORKED] MSDE sp4 installation+osql connect

ok yesterday i crunched my head against the wall, after trying MSDE
installation (MSDE rel.A and MSDE SP4) on a brand new WXPPSP2 laptop.
Today it worked, in this way:
#Prerequisites
1.removed any MSDE installation (control panel > Remove Applications)
2.removed any MSDE directory (eg. "C:\programmi\Microsoft SQL Server") and
subdirs
3.removed any MSSQL regKey (Regedit.exe > HKLM\Software\Microsoft, keys
named "Microsoft SQL Server" or "MSDE", i browsed by intuition)
#Installation
i used following installation parameters:
BLANKSAPWD=1 (testing purposes only, next i'll check SAPWD="strongpwd")
INSTANCENAME ="theinstance"
DATADIR = "c:\Program Files\Microsoft SQL Server\MSSQL$theinstance\data\"
(notice the final backslash)
/L*v "C:\msde.log"
#Connection
$ osql -S (local)\theinstance -E
using -U sa with no input as password i get the error "Access denied for
"sa" user. Reason: not associated with a trusted SQL Server connection"
since i installed with blank sa pwd. (In theory sa should gain access with
no password specified)
actually, if you install MSDE without specificating the authentication mode,
the installation sets the login authentication to Windows authentication
mode, not the integrated one, hence you cannot access with builtin users
login.
See http://support.microsoft.com/default...;EN-US;Q285097
for further infos.

> #Connection
> $ osql -S (local)\theinstance -E
> using -U sa with no input as password i get the error "Access denied for
> "sa" user. Reason: not associated with a trusted SQL Server connection"
> since i installed with blank sa pwd. (In theory sa should gain access with
> no password specified)

[news] free copy of SQL Prompt

so last week i finally downloaded and installed SQL Server 2005, and along with that, i downloaded Studio Express (i had previoulsy been using MSDE with WinSQL by Synametrics)

anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate

i tried it, and i like it!!

see http://builder.com.com/5100-6388_14-6085249.html?part=rss&subj=bldrEDIT - Coo - my first post did stick|||anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate

i tried it, and i like it!!Harrumph. I paid $25 USD for my copy before Red Gate bought the product. So long as they keep developing it though (doesn't pick up functions, can't handle subqueries and derived tables etc yet) then I am happy :)

[NEWBIE] Replication with MSDE 2000

Hi everybody,
can someone help me about replication ?
I want to install msde2000 on two machines (identical) and keep database
updated like mirroring, so my users can connect to mirrored data if primary
server crashed down.
The two machines are in my LAN with their own IP number
Is it Possible ?
Thanks in advance and sorry of my poor knowledge of MSDE features
Merlinweb
Hi Merlinweb,
Merge replication goes close to doing what you want if you keep it
synchronizing constantly. There is some latency with the updates but that's
ok in many scenarios. It works very well when the servers are on the same
LAN. You will need to consider though, how to make schema changes, etc. as
that introduces quite a few issues.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"il_Leva" <il_levaMACIAO@.hotmail.com> wrote in message
news:41c97bf0$1@.x-privat.org...
> Hi everybody,
> can someone help me about replication ?
> I want to install msde2000 on two machines (identical) and keep database
> updated like mirroring, so my users can connect to mirrored data if
> primary
> server crashed down.
> The two machines are in my LAN with their own IP number
> Is it Possible ?
> Thanks in advance and sorry of my poor knowledge of MSDE features
> Merlinweb
>
|||"Greg Low [MVP]" <greglow@.lowell.com.au> ha scritto nel messaggio
news:uDw9mGI6EHA.2584@.TK2MSFTNGP10.phx.gbl...
> Hi Merlinweb,
> Merge replication goes close to doing what you want if you keep it
> synchronizing constantly. There is some latency with the updates but
that's
> ok in many scenarios. It works very well when the servers are on the same
> LAN. You will need to consider though, how to make schema changes, etc. as
> that introduces quite a few issues.
Thank you very much !
Now I go and search something useful on the net about merge replication.
Cheers
Merlinweb

[Fail] Could not add ASPNET user to SQL Server.

Ok here's my setup

1. Installed msde 2000 with sp3.
2. started the SQL Server and SQL Server Agent.
3. Ran IBuySpy Store Installation, when I ran the configuration I get error on bottum.

10:51:55 PM Tuesday, September 23, 2003: [Checking system requirements]
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected a local instance of SQL Server.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected .NET Framework.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected Internet Information Server (IIS).
10:52:03 PM Tuesday, September 23, 2003: [Begin Sample Configuration]
10:52:05 PM Tuesday, September 23, 2003: [Pass] Created IIS virtual directory.: StoreVBVS
10:52:05 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:52:22 PM Tuesday, September 23, 2003: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
10:52:22 PM Tuesday, September 23, 2003: [Done]

Can someone please tell me step by step on what I need to do and where to do it to get this working, thanks !!!did you add it via users in your db? when you xpand our db in sql server xplorer, you can add users using "users"...

HTH

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied

Hi Folks,

Lets get this out of the way first - I KNOW NOTHING ABOUT SQL SERVER, MSDE or MDAC

Sorry I don't mean to shout but I really don't know anything at all so please make your answers as simple as possible.

I have an application (Webmarshall) that has a SQL database from which certain reports are run. Whenever I try to run the reports it asks me for database details.

According to the application it is using LANCELOT\WEBMARSHALL\Webmarshall as the database

As this is all happening on one server, I presume it is local and not remote.

When I am presented with the dialogue box for the reporting module it asks for a server and a database, I have tried the following :

Server: local Auth: Windows

Server: local Auth: SQL

Server lancelot (both authorisation methods)

Server: lancelot\webmarshall (both authorisation methods)

Server: \\lancelot\webmarshall (both authorisation methods)

Each time, I get the message

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied

and I can't select a database.

Can someone help me please...its a long time since I went fishing in the dark (with no net) but thats how I feel right now!!!!

Thanks

In the SQL Server menu options on your Start menu, do you have Enterprise Manager? (you may not depending on which version of SQL Server you have and which installation options were selected, but if you do things will be simpler)

When you try to connect with SQL Auth, are you using a user name and password that are known to be correct? Windows Auth may not work simply because your Windows user may not have permission to connect.

|||

Hi Guys,

Thanks for the response, in the end I was so confused by it all that I got a (SQL experienced and very trusted) colleague to remote onto my server.

It turns out that it was MSDE, and that for some reason the connection details had all been lost during the upgrade process. We eventually found the user buried deep in the properties of the application, changed the password and now it all works OK

Perhaps I need to start learning more about SQL, and stop playing with exchange all day!!!!!!

Thanks again

[DBNETLIB] General Network Error - (I have included the event log dump.)

I have a MS MSDE 2000 database that is serving 3 database clients. Intermittently, randomly, and more important daily, my clients receive a "SQL Database Connection Error", and they are kicked out of the database. This appears to be correlated when they are writing/retrieving a record.

MS MSDE then writes the following error in it's event log.

----------
Source: SORules.Gateway.LogErrors
Process ID: 2328

Database connection lost
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
(Source: Microsoft OLE DB Provider for SQL Server)
(SQL State: 08S01)
(NativeError: 11)
No Help file available

OpenRsRead
System.Runtime.InteropServices.COMException (0x80004005): [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
at ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
at SORules.Gateway.OpenRsRead(Command& C, Boolean& ForwardOnlyCursor)
Stack trace:
at ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
at SORules.Gateway.OpenRsRead(Command& C, Boolean& ForwardOnlyCursor)
----------

Any help, suggestions, or thoughts would be greatly appreciated. This is for a small business line of business application that is critical for everyday business operations. These problems have resulted in lost work, short tempers, and a just frank frustration.

I am just getting started with MS SQL technologies and really need some quality help.

Thank you for your time, and have a great day.

Cheers,
MarkBasically this means that there is a "connection problem" between the client and server parts of the SQL Server software. The error isn't specific because there are way too many places for these kinds of problems to hide, most of which can't be found by the machine that notices the problem.

If the people are having regular network problems (slowness, problems reaching specific machines in their networks, web browsing issues, etc), then fixing those problems should also fix the SQL problem.

If they aren't having regular network problems, then you have to play a bit of Sherlock Holmes to track down the culprit. If I were in this situation, I'd check:

1. Visit the Windows Update site from each machine using SQL. Be sure to get the latest windows and driver patches.
2. Ping the database server from each machine, investigate any significant differences in ping times.
3. Check the Network Interface Card in each machine (including the server)
4. Check the network hardware (routers, etc)
5. Come back here if that doesn't help.

-PatP

[2005 Express]Add SPs to a Schema?

I have SQL Server 2005 Express set up on a PC. I imported a backup of an MSDE database. All of the database objects are there. However, I need to assign permissions to my Stored Procedures. So, using Management Studio Express, I saw absolutely no way of adding a stored procedure to a schema or to a user. So I downloaded SQL Server 2005 Developer from my MSDN account. I installed the client tools to get the full version of Management Studio. Same thing. No way to add permissions to a SP. Some web articles say to right-click the SP and select Properties. However, there is no "Properties" in the right-click menu!!! There is only Rename, Delete, Modify, etc. How can something so easy with an old product be so difficult with a new one? Does anyone know how to accomplish adding permissions to SPs?

I can right-click a table or a View and get the popup window with the list view and contents to set permissions to tables and views.On my build of SSMS, I do have a properties context menu off of any sproc in OE, and when I click it I can add perms to the sproc. I have this build: 9.00.2047.00. which do you have?

I am thinking perhaps this is due to a bad reaction between SSMS and SSMSE perhaps. EDIT: Is that redundant? :)

If nothig else works, I would try unistalling them both and the reistalling only SSMS.|||I have build 9.00.1399.00, so it is an older version. This build was from MSDN Subscription Downloads, on Disk 2 for SQL Server 2005 Developer. Do you know where I could download an update/the latest version?

UPDATE: I uninstalled and then reinstalled all of the SQL Server Workstation stuff. Then, I installed an instance of SQL Server 2005 Developer on my test PC. Now, with SSMS, I can right-click and get "Properties" for stored Procedures in the SQL Server 2005 instance, but I still can't get the right-click "Properties" in the Express instance. Is this a limitation of Express?|||Yes, I think this is a limitation of ssmse.

The sql express GUI is very limited in what it does. it's meant to be a teaser to make it more attractive for people to start using sql server instead of mysql, but then upgrade to a pay version once they are addicted. :)

EDIT: I am running sp1 - I think that's the difference between our two version numbers. You can download sp1 from here: http://www.microsoft.com/sql/sp1.mspx|||Oh, I see. Even the Management Studio updates are included in the SQL Server service pack, huh? I'll have to apply that. Thanks.|||oh yea. UI devs put bugs in their code too. :)|||Well, overall, I can get the Express instance to run the SPs from my VB.NET code. I used ALTER to put them into a new schema, and gave the user account that connects from my intranet app permissions on that schema. This allows the app to run the SPs. It's odd, what use is setting permissions on the specific SP (in the Developer instance, or course) when just using the schema allows execution? Is it to be more granular with permissions and, say, deny permissions on a specific SP within a schema to a schema user?|||that's one of the points of using schemas.

note that an explicit deny on a sproc should override any indirect grant (thru a schema).