Taggs

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

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

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

Hi gunsmokingman, Thanks for that but unfortunately I have already tried that but to no avail.

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

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

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

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

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

@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

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

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

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?

You could also use gamecam if you wanted to capture Video of the game.

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

The problems I have is that it takes 5-10mins for the domain controllers to automatically sync I want to be able to make the DNS change and then force/speed-up the update across the controllers so the users are not without the service for any length of time. I not sure if I am making sense? Please let me know and I will try and explain a little better Taggs

Does this sync the domain controllers? I know you can do this on the PC's (250+ PC's is a lot of people to talk through and I want it to look seemless for the user) but if you are not connected to the domain controller that I updated then you have to wait the 5-10mins for the update. B)

Here is my scenario. We have a web site on server ‘A’ that people connect to via a DNS entry. Server A’s web site connects to our mainframe via its MAC address through NDIS. I have set up another server (server ‘B’) exactly the same as server ‘A’. If server ‘A’ fails all I need to do is change the DNS entry to point to server ‘B’ and people can carry on working. My problem is when I change the DNS entry on a domain controller, it takes around 5-10 mins for the four domain controllers to sync. The DNS TTL is set to 0. Is there any way to force a windows 2000 domain controller to synchronise its DNS. Or a way of changing all four domain controllers at once? Or a better way to perform this action? Thanks Taggs

I have just not set my region on my DVD player when it asks and it seems to work with any region DVD. One option is to buy another DVD drive and set this to the 'other' region. With a price tag from £18 for a new drive it is not worth all the hassle. Taggs

It sorted it now. I missed the line inside the loop rsfilename.movenext

Hi, I am having a few troubles trying to get my code to work. I am trying to extract recordset data from a database, which includes part of the file name, and then loop against this record set to check if a file with this name exists or not. Does this make sense? If I remove the loop and just perform the check on the first record it works OK. Any Ideas? Thank you in anticipation Database table Id Filename 1 A 2 B 3 C 4 D 5 E set fs=Server.CreateObject("Scripting.FileSystemObject") if rsfilename.eof then response.write("<p align=""center""> Sorry, the database is empty</p>") else do until rsfilename.eof%> if fs.FileExists("C:\Inetpub\filestorage\images\pic " & trim(rsfilename ("filename")) & ".jpg")=true then response.write("The file pic" & rsfilename ("filename") & ".jpg does Exist.") else response.write("The file pic" & rsfilename ("filename") & ".jpg does not Exist.") end if loop set fs=nothing end if Here is the error I get Response object error 'ASP 0251 : 80004005' Response Buffer Limit Exceeded /coding/numberallocation/showracks.asp, line 0 Execution of the ASP page caused the Response Buffer to exceed its configured limit.

Im getting a little closer. If I do response.write(len(BinaryToString)) response.write(len(request.form("password"))) I get 50 and 8 If I do response.write("B= " & Ascb(MidB(Binary, I, 1)) & " : ") if len(request.form("password")) >= i then response.write("P = " & Ascb(MidB(trim(request.form("password")), I, 1)) & " | ") I get B= 112 : P = 112 | B= 97 : P = 0 | B= 115 : P = 97 | B= 115 : P = 0 | B= 119 : P = 115 | B= 111 : P = 0 | B= 114 : P = 115 | B= 100 : P=0 | B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : B= 0 : the password box is passing a null (or 0) value and the binary string has trailing nulls (or 0's) Sorted My solution Ive changed S = S & Chr(AscB(MidB(Binary, I, 1))) to if Chr(AscB(MidB(Binary, I, 1))) <> Chr(0) then S = S & Chr(AscB(MidB(Binary, I, 1))) end if

I have a simple login page that passes the username and password to a validation page. The password is stored as Binary in an SLQ2000 DB When I perform the check on the two strings if BinaryToString = request.form("password") then valid=1 it always comes back as valid=0 if you display the two values they are the same. I suspect there are control chars on the end of the string. Can anyone help please. <html> <% Function BinaryToString(Binary,valid) 'SimpleBinaryToString converts binary data (VT_UI1 | VT_ARRAY Or MultiByte string) 'to a string (BSTR) using MultiByte VBS functions Dim I, S valid=0 For I = 1 To LenB(Binary) S = S & Chr(AscB(MidB(Binary, I, 1))) Next BinaryToString = S if BinaryToString = request.form("password") then valid=1 End Function %> <head> <title>Validation</title> </head> <body> <% Dim conn2 Set conn2 = Server.CreateObject("ADODB.Connection") conn2.Open "DSN=Serverdetails; User Id = Administrator; Password=******" Sqlgetuser="select * from users where Username='" & request.form("username") & "'" set rs = conn2.execute(sqlgetuser) Dim temppass Dim valid valid=0 temppass = BinaryTostring(rs("password"),valid) if rs.eof then response.write("User " & request.form("username") & " not found!") session("password") = "" session("username") = "" elseif valid=1 then session("user") = request.form("username") session("permissions") = rs("permissions") Response.Redirect("/index.htm") else response.write("Password incorrect!") session("password") = "" session("username") = "" end if %> </body> </html>

I do Apologise but the fix was not with the code. It was with the IE settings. You need to set Intialize and script ActiveX controls not marked as safe to enabled.

FANTASTIC Thats worked a treat!