Taggs

Member
  • Content count

    185
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Taggs

  • Rank
    Taggs
  • Birthday 04/27/1974

Contact Methods

  • Website URL
    http://
  1. HI no17, is this for setting up a KMS client or KMS host? I am trying to setup a KMS host server. From what I read you should not need to specify a computer name and port number becuase I have already set this up in AD? Thanks Taggs
  2. I have a mixure of SQL servers in my estate. SQL 2k5 on Win 2k3 SQL 2k5 on Win 2k8 SQL 2k5 on Win 2k8(shared Cluster server) SQL 2k8 on Win 2k8(shared Cluster server) I have set the memory allocation (max and min) for SQL server on each installation. When I looked at the memory allocation in Task manager on my SQL 2k5 on Win 2k3 and SQL 2k5 on Win 2k8 it shows the SQL service as using the allocated memory. When I look at the other SQL installs it shows as not using the allocated memeory. I started to do a little investigation and reading posts on the web people seem to think this is buffer memory allocation and does not show in task manager. I am quite willing to believe this but why do some of my servers show SQL is using the memeory (in task manager) and some show it is not? I can't see a corolation in SQL versions or OS versions! I do have PLIM set on my cluster but after looking into this I don't believe this has anything to do with it. Thanks Taggs
  3. Hi, I am wondering if some one could help me please or at least point me in the right direction for KMS hosting. I'm "trying" to setup 2 KMS servers for my organisation. 100+ server 5000+ PC's I've setup the AD groups (for cross domain licening) I've configured DNS with the SRV records (plus permissions) I've then run the following commands slmgr.vbs /ipk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx slmgr.vbs /ato SLMgr.vbs /SPrt XXXX (where xxxx is our new port number) I have also downloaded and setup KMS for Office 2010 (which seems to be working) My problem being if I try to install our KMS key from MS I get the following errors "The Software Licensing Service reported that the license is not installed" for my Windows Server 2008 Std/Ent KMS B key and "The software Licensing Service reported that the product key is invalid" for my Win 7 - KMS key (I've checked,checked and checked again and this is the correct key!) After trying all my keys the only one I have managed to get on (besides offce 2010) is Win Srv 2008 R2 Data Ctr/Itan KMS C This is driving me crazy as it should be so simple (or maybe it's just I'm so thick) My server is Win 2008 R2 and I have registered it with MS. Thanks Taggs
  4. Hi gunsmokingman, Thanks for that but unfortunately I have already tried that but to no avail.
  5. Hi Guys, I'm trying to perform an automated bulk insert of a file each day, which contains the date in the file name. If I enter the file name it runs fine so I think it is just the formatting of the code/string but I am struggling to find what it can be (if at all possible). The code extract is BULK Insert HDD_Info_temp from 'c:\support\bulkimport\HDD-REPORT-SUCCESS_' + (select convert(varchar,(CAST(CONVERT(varchar, GetDate(), 105) AS DateTime)),105)) + '-09-17-00.csv' with (fieldterminator = ',',rowterminator ='\n') go the error I get is Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '+'. Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '+'. if I run the statement select ('c:\support\bulkimport\HDD-REPORT-SUCCESS_' + (select convert(varchar,(CAST(CONVERT(varchar, GetDate(), 105) AS DateTime)),105)) + '-09-17-00.csv') I get the required string Any idea's or is it not possible via TSQL Taggs
  6. OK I have a solution (from a post on another forum) The problem is USE looks for an Identifier The solution is exec('use ' + @database + '; <other statement/s here>) At the moment the job is reliant on the fact that the lodgical name is the same as the DB name My final code looks like this Declare @database_name varChar(50),@database_name_temp varChar(54) Declare database_name_CURSOR CURSOR FOR select name from sys.sysdatabases where dbid >4 order by name OPEN database_name_CURSOR FETCH NEXT FROM database_name_CURSOR into @database_name While @@FETCH_STATUS = 0 Begin Set @database_name_temp= @database_name + '_Log' exec('use ' + @database_name + '; DBCC ShrinkFile (' + @database_name_temp + ',10); Backup log ' + @database_name + ' with Truncate_only; DBCC ShrinkFile (' + @database_name_temp + ',10)') FETCH NEXT FROM database_name_CURSOR into @database_name End Close database_name_CURSOR; Deallocate database_name_CURSOR
  7. Hi, I am trying to automate a Log Shrink File for all databases on our SQL Server (2005). I have a script that works to a fashion but I am having problems with one command. Declare @database_name varChar(50),@database_name_temp varChar(54) Declare database_name_CURSOR CURSOR FOR select name from sys.sysdatabases where dbid >4 order by name OPEN database_name_CURSOR FETCH NEXT FROM database_name_CURSOR into @database_name While @@FETCH_STATUS = 0 Begin Set @database_name_temp= @database_name + '_Log' Use @database_name DBCC ShrinkFile (@database_name_temp,10) Backup log @database_name with Truncate_only DBCC ShrinkFile (@database_name_temp,10) FETCH NEXT FROM database_name_CURSOR into @database_name End Close database_name_CURSOR; Deallocate database_name_CURSOR The problem is with the command Use @database_name the error message I get is Msg 102, Level 15, State 1, Line 8 Incorrect syntax near '@database_name'. If I substitute for a real Database name it works for that database (but no others obviously) Thanks Taggs
  8. Hi, Does anybody know of a way of forcing the -E switch at startup of SQL Server Management tools? Or Opening the database component as default (rather than SQL query). I'm trying to publish SQL client tools through citrix but I want to force the login to be the authenticated user. I have put the -E switch on the application startup but when I try to open the database it asks me to log on again. (Where I can switch the user to an sql user, which i dont want the users to be able to do) I did find this to open the component but it didn't work Cheers Taggs
  9. I have just tested this again and it seems to be working now. Hmmmmmmmmmmmm Not sure if I want to enable this on my live app until I can find out why. I think I will create some new sites and see if I can re-create. Thanks for the help guys Taggs P.S. I will post back if I find anything useful
  10. @Stoic Joker I have tried all combinations of user name I can think of Username DomainName\UserName UserName@DomainName localmachine\admin machinename.domain\username @cluberti I will try and get some network traces
  11. I always lock my computer at work as I have high level rights and I dont want to leave it so people could come and sit at my PC and elevate their rights or "misuse" the system using my account. At home I don't bother locking my PC as I very rarely leave it long enough for my wife to find my "educational" films ;-) (which are well hidden) plus my wife has her own PC so has no need to use mine
  12. Hi Stoic Joker, I have read here here on the MS site that IIS will pick the strongest authentication and then works its way down the list until it gets to a protocol that both sides support. So it should work with both selected. Saying that, I have tried with just one or the other and it still did not work. Regards Taggs
  13. I am trying to get IIS authentication through our domain but I can't seem to get it to work. I have a w2k domain. My web site is run on a w2k3 server which is a member of the domain. I have set integrated windows and Digest Authentication on. Unchecked Enable anonymous access. When trying to access the site I get my login box but it does not accept the credentials. I am an enterprise admin. The Title of the box says 'Connect to <websiteheader.domainname>' I get three tries and then I get - You are not authorized to view this page If I try to connect to the site through our VPN connection it works. Any Idea's?
  14. You could also use gamecam if you wanted to capture Video of the game.
  15. Thanks for the comments but comments like that are not really helpful at all for getting an answer to my problem. I have already gone through these solutions and they do not fit this problem. I also know what the problem is (network problem which does not happen very often and of which we have no control and I do not want to go off on a tangent talking about it). Network load balancing will not work either as IIS site will still be running but mainframe connection dropped, therefore connections will still be put through to a server not working. I want to provide the best service I can to my users and if I can sort this problem, the service will be improved. Thanks Taggs